1064 - 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 '\'Batik\' ) AND ps3.specifications_id = '3' ' at line 4

select count(p.products_id) as count from (products p) join (products_to_categories p2c) on (p.products_id = p2c.products_id) INNER join products_specifications ps3 ON p.products_id = ps3.products_id where (p.manufacturers_id in (0,1) OR p.manufacturers_id IS NULL) and p.products_status = '1' AND p.available in (0,1) and (p.customers_id is null or p.customers_id = 0) and p.visible = 1 and p2c.categories_id = '656' AND ps3.specification in (\'Batik\' ) AND ps3.specifications_id = '3' AND ps3.language_id = '1'

[TEP STOP]