~error~ SELECT TR.*, TD.* FROM tbl_dosya AS TD LEFT JOIN tbl_resim AS TR ON TD.haber_id = TR.haber_id WHERE 1 AND TD.yazan != '' AND LENGTH(TD.yazan) = 10 AND TD.bolum= AND yazan BETWEEN '2008-01-01' AND '2008-12-31' ORDER BY TD.yazan cumlesinde 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 'AND yazan BETWEEN '2008-01-01' AND '2008-12-31' ORDER BY TD.yazan' at line 1