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 range_id = )' at line 1SELECT id FROM categories WHERE id IN (SELECT category_id FROM products WHERE genre_id =  AND range_id = )