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 ') group by products_group' at line 1
select count(*) as count, products_group from products where products_status = '1' and products_group in () group by products_group