1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
in:
[select count(distinct p.products_id) as total FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) 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 p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%schwarzer%' OR p.products_model LIKE '%schwarzer%' OR m.manufacturers_name LIKE '%schwarzer%' OR (mtpd.metatags_keywords LIKE '%schwarzer%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%schwarzer%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%freitag%' OR p.products_model LIKE '%freitag%' OR m.manufacturers_name LIKE '%freitag%' OR (mtpd.metatags_keywords LIKE '%freitag%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%freitag%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%coach%' OR p.products_model LIKE '%coach%' OR m.manufacturers_name LIKE '%coach%' OR (mtpd.metatags_keywords LIKE '%coach%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%coach%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%x%' OR p.products_model LIKE '%x%' OR m.manufacturers_name LIKE '%x%' OR (mtpd.metatags_keywords LIKE '%x%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%x%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%keith%' OR p.products_model LIKE '%keith%' OR m.manufacturers_name LIKE '%keith%' OR (mtpd.metatags_keywords LIKE '%keith%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%keith%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%haring%' OR p.products_model LIKE '%haring%' OR m.manufacturers_name LIKE '%haring%' OR (mtpd.metatags_keywords LIKE '%haring%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%haring%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%rogue%' OR p.products_model LIKE '%rogue%' OR m.manufacturers_name LIKE '%rogue%' OR (mtpd.metatags_keywords LIKE '%rogue%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%rogue%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%sky%' OR p.products_model LIKE '%sky%' OR m.manufacturers_name LIKE '%sky%' OR (mtpd.metatags_keywords LIKE '%sky%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%sky%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%blau/schwarz%' OR p.products_model LIKE '%blau/schwarz%' OR m.manufacturers_name LIKE '%blau/schwarz%' OR (mtpd.metatags_keywords LIKE '%blau/schwarz%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%blau/schwarz%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%copper%' OR p.products_model LIKE '%copper%' OR m.manufacturers_name LIKE '%copper%' OR (mtpd.metatags_keywords LIKE '%copper%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%copper%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%f��r%' OR p.products_model LIKE '%f��r%' OR m.manufacturers_name LIKE '%f��r%' OR (mtpd.metatags_keywords LIKE '%f��r%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%f��r%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%damen%' OR p.products_model LIKE '%damen%' OR m.manufacturers_name LIKE '%damen%' OR (mtpd.metatags_keywords LIKE '%damen%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%damen%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%zeapx2i4%' OR p.products_model LIKE '%zeapx2i4%' OR m.manufacturers_name LIKE '%zeapx2i4%' OR (mtpd.metatags_keywords LIKE '%zeapx2i4%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%zeapx2i4%' AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%online-verkauf%' OR p.products_model LIKE '%online-verkauf%' OR m.manufacturers_name LIKE '%online-verkauf%' OR (mtpd.metatags_keywords LIKE '%online-verkauf%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%online-verkauf%' AND mtpd.metatags_description !='')) ))]