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_options_values.products_options_values_id order by products' at line 8
in:
[select count(products_attributes.products_id), products_options_values.products_options_values_id,products_options_values.products_options_values_name from products_attributes left join products_options_values on products_attributes.options_values_id = products_options_values.products_options_values_id left join products on products_attributes.products_id = products.products_id where products_options_values.language_id = 1 and products_attributes.options_id = 2 and products.products_quantity >0 and products.products_status >0 and products.manufacturers_id in ) group by products_options_values.products_options_values_id order by products_options_values.products_options_values_name ]