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 `deliver_valid`='1'' at line 1 -> SELECT COUNT(*) FROM `deliver` LEFT JOIN `agency` USING(`agency_id`) WHERE `deliver_id` IN () AND `deliver_valid`='1'