1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
in:
[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 WHERE (p.products_status = 1 AND pd.language_id = 1 AND ((pd.products_name LIKE '%converse%' OR p.products_model LIKE '%converse%' OR m.manufacturers_name LIKE '%converse%' OR (mtpd.metatags_keywords LIKE '%converse%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%converse%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%chuck%' OR p.products_model LIKE '%chuck%' OR m.manufacturers_name LIKE '%chuck%' OR (mtpd.metatags_keywords LIKE '%chuck%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%chuck%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%taylor%' OR p.products_model LIKE '%taylor%' OR m.manufacturers_name LIKE '%taylor%' OR (mtpd.metatags_keywords LIKE '%taylor%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%taylor%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%all%' OR p.products_model LIKE '%all%' OR m.manufacturers_name LIKE '%all%' OR (mtpd.metatags_keywords LIKE '%all%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%all%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%star%' OR p.products_model LIKE '%star%' OR m.manufacturers_name LIKE '%star%' OR (mtpd.metatags_keywords LIKE '%star%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%star%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%wp%' OR p.products_model LIKE '%wp%' OR m.manufacturers_name LIKE '%wp%' OR (mtpd.metatags_keywords LIKE '%wp%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%wp%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%sneaker%' OR p.products_model LIKE '%sneaker%' OR m.manufacturers_name LIKE '%sneaker%' OR (mtpd.metatags_keywords LIKE '%sneaker%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%sneaker%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%botas%' OR p.products_model LIKE '%botas%' OR m.manufacturers_name LIKE '%botas%' OR (mtpd.metatags_keywords LIKE '%botas%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%botas%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%t67n7826mt92%' OR p.products_model LIKE '%t67n7826mt92%' OR m.manufacturers_name LIKE '%t67n7826mt92%' OR (mtpd.metatags_keywords LIKE '%t67n7826mt92%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%t67n7826mt92%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%p��rpura%' OR p.products_model LIKE '%p��rpura%' OR m.manufacturers_name LIKE '%p��rpura%' OR (mtpd.metatags_keywords LIKE '%p��rpura%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%p��rpura%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%de%' OR p.products_model LIKE '%de%' OR m.manufacturers_name LIKE '%de%' OR (mtpd.metatags_keywords LIKE '%de%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%de%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%los%' OR p.products_model LIKE '%los%' OR m.manufacturers_name LIKE '%los%' OR (mtpd.metatags_keywords LIKE '%los%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%los%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%hombres%' OR p.products_model LIKE '%hombres%' OR m.manufacturers_name LIKE '%hombres%' OR (mtpd.metatags_keywords LIKE '%hombres%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%hombres%' AND mtpd.metatags_description !='')) )) GROUP BY p.products_id ]