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 WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY IN (10298) AND DATE_TO_ENABLE <= 'checkdatetime' ORDER BY mdocs.mdoc_update DESC, DATE_ONLINE DESC,DATE_TO_ENABLE DESC ASC LIMIT 150
vorher:
SELECT mdoc_id FROM content_table,mdocs WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY IN (10298) AND DATE_TO_ENABLE <= 'checkdatetime' ORDER BY mdocs.mdoc_update DESC, DATE_ONLINE DESC,DATE_TO_ENABLE DESC ASC LIMIT 150
nachher:
SELECT mdoc_id FROM content_table,mdocs WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND DATE_ONLINE <= 'checkdate' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Öamtc' AND ID_KEY IN (10298) AND DATE_TO_ENABLE <= 'checkdatetime' ORDER BY mdocs.mdoc_update DESC, DATE_ONLINE DESC,DATE_TO_ENABLE DESC ASC LIMIT 150
Langstreckenflüge nach Johannesburg und von Kapstadt retour
13 Tage Erlebnisreise: Pretoria – Krügerpark – Garden Route – Route 62 –
Kapstadt und das Kap der guten Hoffnung
9 bzw. 12 Tage inkl. Halbpension (2 Tage Vollpension) und 4 Ausflügen!
Zum Frühbucherpreis (sparen Sie bis zu EUR 220,-)
Alle Ferientermine ohne Aufpreis!
