KEYWORD_A,KEYWORD_A_NAME,DOC_TYPE,ID_KEY,TITLE,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 = 10004 AND KEYWORD_A = '140' /mdocs.mdoc_update desc, DATE_ONLINE DESC

SELECT KEYWORD_A,KEYWORD_A_NAME,DOC_TYPE,ID_KEY,TITLE,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 = 10004 AND KEYWORD_A = '140' AND KEYWORD_A = '140' ORDER BY mdocs.mdoc_update desc, DATE_ONLINE DESC

vorher: SELECT KEYWORD_A,KEYWORD_A_NAME,DOC_TYPE,ID_KEY,TITLE,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 = 10004 AND KEYWORD_A = '140' AND KEYWORD_A = '140' ORDER BY mdocs.mdoc_update desc, DATE_ONLINE DESC

nachher: SELECT KEYWORD_A,KEYWORD_A_NAME,DOC_TYPE,ID_KEY,TITLE,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 = 10004 AND KEYWORD_A = '140' AND KEYWORD_A = '140' ORDER BY mdocs.mdoc_update desc, DATE_ONLINE DESC