1064 - 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 language_id =1' at line 1

SELECT t1.village_id as obj_ID, t1.village_name as obj_NAME, t1.village_image as obj_IMAGE, t1.village_map as obj_MAP, t2.village_description as obj_DESCRIPTION, t3.region_id as region_ID, t3.region_name as region_NAME FROM immo_villages AS t1 JOIN immo_villages_description AS t2 on t2.village_id = t1.village_id JOIN immo_regions AS t3 on t1.region_id = t3.region_id where t1.village_id= AND language_id =1

[TEP STOP]