2-SQL SELECT vk.id, vk.titel, veranstalter, vk.ort_name, DATE_FORMAT( uhrzeit, '%Y%m%d' ) AS sort_datum, DATE_FORMAT( uhrzeit, '%H%i' ) AS sort_zeit, DATE_FORMAT( uhrzeit, '%d.%m.%Y' ) AS datum, DATE_FORMAT( uhrzeit, '%H:%i' ) AS zeit, DATE_FORMAT( uhrzeitbis, '%H:%i' ) AS zeitbis, pia_rubrik_parameter.zusatzausgabe FROM vk LEFT JOIN pia_rubrik_parameter ON ( pia_rubrik_parameter.nr2 = vk.oberrubrik_nr ) LEFT JOIN ver ON (vk.veranstalter_id=ver.id) WHERE vk.avk1_id = 6178600 AND vk.veranstalter_id = 10135616 AND datum >= curdate() AND ADDDATE( '2010-09-09 11:20:55', INTERVAL 7 DAY ) >= datum AND vk.stopper=0 AND vk.stopper2=0 AND ((vk.region_id=6412) OR (ver.sel_myfrankfurt && pia_rubrik_parameter.sel_myfrankfurt_flag )) AND vk.update_nr<>3 ORDER BY veranstalter_id, sort_datum, sort_zeit FAIL:Unbekanntes Tabellenfeld 'vk.ort_name' in field list