Wholesale Clothing Women Women Blazer

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 ') and gender in ('') and status='1' GROUP BY m.manufacturers_id HAVING cnt > 0' at line 8

SELECT m.manufacturers_id as id, m.manufacturers_name as name, gender, COUNT(*) AS cnt FROM `products` JOIN manufacturers m ON m.manufacturers_id = products.manufacturers_id JOIN products_to_categories ptc on ptc.products_id = products.products_id join products_description on products.products_id=products_description.products_id join categories c on c.categories_id = ptc.categories_id join categories_description on categories_description.categories_id = c.categories_id where 1 like 1 and products_status=1 and categories_description.language_id=2 AND ptc.categories_id in (59) and stagione in () and gender in ('') and status='1' GROUP BY m.manufacturers_id HAVING cnt > 0 ORDER BY m.manufacturers_name ASC

[TEP STOP]