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 mdoc_id FROM content_table,mdocs,content_table.KEYWORD_C WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY IN (10162,10298,10341) AND DATE_TO_ENABLE <= 'checkdatetime' AND content_table.KEYWORD_C.KEYWORD_C = '180' ORDER BY mdocs.mdoc_update DESC, DATE_ONLINE DESC,DATE_TO_ENABLE DESC ASC LIMIT 150
vorher:
SELECT mdoc_id FROM content_table,mdocs,content_table.KEYWORD_C WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY IN (10162,10298,10341) AND DATE_TO_ENABLE <= 'checkdatetime' AND content_table.KEYWORD_C.KEYWORD_C = '180' ORDER BY mdocs.mdoc_update DESC, DATE_ONLINE DESC,DATE_TO_ENABLE DESC ASC LIMIT 150
nachher:
SELECT mdoc_id FROM content_table,mdocs,content_table.KEYWORD_C WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY IN (10162,10298,10341) AND DATE_TO_ENABLE <= 'checkdatetime' AND content_table.KEYWORD_C.KEYWORD_C = '180' ORDER BY mdocs.mdoc_update DESC, DATE_ONLINE DESC,DATE_TO_ENABLE DESC ASC LIMIT 150
