SELECT id, start, end, (SELECT file FROM d_Filemanager WHERE d_Filemanager.id = file) as dl_file, (SELECT folder FROM d_Filemanager WHERE d_Filemanager.id = file) as dl_folder, (SELECT type FROM d_Filemanager WHERE d_Filemanager.id = file) as dl_type, (SELECT beschreibung FROM d_Filemanager WHERE d_Filemanager.id = file) as dl_beschreibung, (SELECT file FROM d_Filemanager WHERE d_Filemanager.id = image) as image_file, (SELECT folder FROM d_Filemanager WHERE d_Filemanager.id = image) as image_folder, link, link_name, headline, subline, beschreibung, beschreibung2, vorlauf FROM d_News WHERE end < NOW() AND aktiv = 1 AND bereich = 1 AND YEAR(start) = 2011 AND MONTH(start) = 7 ORDER BY start DESC LIMIT 5;

Archiv