DOC_TYPE,ID_KEY,TITLE,HEADLINE,SUBTITLE,SUMMARY |
WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND (CLOSED_DOC <= 1 OR CLOSED_DOC IS NULL) AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY = 10038 /mdocs.mdoc_update desc, DATE_ONLINE DESC

SELECT DOC_TYPE,ID_KEY,TITLE,HEADLINE,SUBTITLE,SUMMARY,DATE_ONLINE,mdoc_id,mdocs.mdoc_update FROM content_table,mdocs WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND (CLOSED_DOC <= 1 OR CLOSED_DOC IS NULL) AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY = 10038 ORDER BY mdocs.mdoc_update desc, DATE_ONLINE DESC

vorher: SELECT DOC_TYPE,ID_KEY,TITLE,HEADLINE,SUBTITLE,SUMMARY,DATE_ONLINE,mdoc_id,mdocs.mdoc_update FROM content_table,mdocs WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND (CLOSED_DOC <= 1 OR CLOSED_DOC IS NULL) AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY = 10038 ORDER BY mdocs.mdoc_update desc, DATE_ONLINE DESC

nachher: SELECT DOC_TYPE,ID_KEY,TITLE,HEADLINE,SUBTITLE,SUMMARY,DATE_ONLINE,mdoc_id,mdocs.mdoc_update FROM content_table,mdocs WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND (CLOSED_DOC <= 1 OR CLOSED_DOC IS NULL) AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY = 10038 ORDER BY mdocs.mdoc_update desc, DATE_ONLINE DESC