SELECT td.*, tso.bezeichnung, tso.id AS spielort_id, tso.url AS spielort_url, ts.stadt_e, ts.id AS stadt_id, tl.land_e, tl.id AS land_id,tc.credit_e FROM em_tour_zusatz AS tz LEFT JOIN em_link_tour_daten_tour_zusatz AS lnk ON lnk.tour_zusatz_id = Internationale Ensemble Modern Akademie LEFT JOIN em_tour_daten AS td ON lnk.tour_daten_id = td.id LEFT OUTER JOIN em_tour_spielort AS tso ON td.tour_spielort_id = tso.id LEFT OUTER JOIN em_tour_stadt AS ts ON tso.tour_stadt_id = ts.id LEFT OUTER JOIN em_tour_land AS tl ON ts.tour_land_id = tl.id LEFT OUTER JOIN em_tour_credit AS tc ON td.tour_credit_id = tc.id WHERE tz.id = Internationale Ensemble Modern Akademie AND ((datum >= '2010-02-08' AND datum <= '2099-12-31') OR (datum_zusatz >= '2010-02-08' AND datum_zusatz <= '2099-12-31')) ORDER BY datum,uhrzeit
tourplan.php You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Ensemble Modern Akademie LEFT JOIN em_tour_daten AS td ON lnk.tour_daten_' at line 4