SELECT COUNT(*) cpt FROM site_item JOIN sitelnk_item_category ON sitelnk_item_category.fk_item_id = site_item.id JOIN sitelnk_label_item ON sitelnk_label_item.fk_item_id = site_item.id JOIN label ON label.id = sitelnk_label_item.fk_label_id WHERE 1 AND sitelnk_item_category.fk_category_id= AND label.fk_lang_id=1 ORDER BY label.label <hr />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 label.fk_lang_id=1 ORDER BY label.label' at line 1