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 'Strand' at line 1 SELECT landiso, a.ortid, IF(b.orttext <> '', b.orttext, a.orttext) as orttext, a.orttext as ort, plz, latitude, longitude, wetter, a.benutzer, a.temp FROM geo_ort a LEFT JOIN geo_ort_sprache b ON a.ortid = b.ortid AND sprache = 'de' WHERE a.ortid = 6432 Strand