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 \' 0\' at line 6 SQL=SELECT p.*, t.name AS typename\n FROM jos_hp_properties AS p\n LEFT JOIN jos_hp_prop_types AS t ON p.type = t.id\n WHERE p.published=1 AND price>=5 AND price<=20 AND beds=1\nORDER BY p.price asc\nLIMIT , 0