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 '='1' AND prt_lmrg_itms_466.field_13='1' AND prt_lmrg_itms_466.id_item=prt_lmrg_' at line 1SELECT COUNT(ofr_lmrg_sys_items.id_item) as cnt FROM lmrg_itms_466 as prt_lmrg_itms_466, lmrg_itms_466 as ofr_lmrg_itms_466, lmrg_sys_items as prt_lmrg_sys_items LEFT JOIN lmrg_sys_items as ofr_lmrg_sys_items ON ofr_lmrg_sys_items.id_prototype=prt_lmrg_sys_items.id_item WHERE ofr_lmrg_sys_items.field_1='1' AND ofr_lmrg_sys_items.b_display='1' AND prt_lmrg_itms_466.field_9>'1' AND ofr_.='1' AND prt_lmrg_itms_466.field_13='1' AND prt_lmrg_itms_466.id_item=prt_lmrg_sys_items.id_item AND ofr_lmrg_itms_466.id_item=ofr_lmrg_sys_items.id_item ORDER BY prt_lmrg_itms_466.field_9 ASC
