1267 Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_general_ci,IMPLICIT) for operation 'find_in_set'
[select distinct p.products_id FROM products p LEFT JOIN manufacturers m USING(manufacturers_id) LEFT JOIN products_description pd on p.products_id = pd.products_id JOIN products_to_categories p2c on p.products_id = p2c.products_id JOIN categories c on p2c.categories_id = c.categories_id LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 JOIN products_attributes p2a on p.products_id = p2a.products_id JOIN products_options po on p2a.options_id = po.products_options_id JOIN products_options_values pov on p2a.options_values_id = pov.products_options_values_id WHERE (p.products_status = 1 AND pd.language_id = 1 AND ((pd.products_name LIKE '%protège%' OR p.products_model LIKE '%protège%' OR m.manufacturers_name LIKE '%protège%' OR (mtpd.metatags_keywords LIKE '%protège%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%protège%' AND mtpd.metatags_description !='')) )) GROUP BY p.products_id HAVING ( FIND_IN_SET("Cat��gorie4", GROUP_CONCAT(CONCAT(REPLACE(po.products_options_name, " ", ""), pov.products_options_values_name))))]