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 set_collection=36 GROUP BY set_id' at line 1
SELECT sets.*, count(si.si_item_id) as count, count(si.si_item_id) as present from sets LEFT JOIN sets_items si ON (set_id=si.si_set_id) LEFT JOIN items i ON (si.si_item_id=i.item_id AND i.item_status=0) WHERE set_public=1 AND set_user= AND set_collection=36 GROUP BY set_id