Reiseberichte Suchergebnis

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 = 'auto touring' AND ID_KEY = 10016 /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 = 'auto touring' AND ID_KEY = 10016 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 = 'auto touring' AND ID_KEY = 10016 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 mdoc_id NOT IN (1424559,825910,825577,827703,827702,827704,827705,827706,827708,827703,827702,827704,827705,827707,827708,827703,827702,827704,827706,827707,827708,827703,827702,827704,827705,827706,827707,827703,827704,827705,827706,827707,827708,827086,827087,827089,827090,825807,825809,825811,825797,825809,825811,826101,829271,829272,825797,825807,825811,829270,829272,829270,829271) AND 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 = 'auto touring' AND ID_KEY = 10016 ORDER BY mdocs.mdoc_update desc, DATE_ONLINE DESC