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 '%levi\'s%'
OR p.products_model
LIKE '%levi\'s%'
OR m.manufacturers_name
LIKE '%levi\'s%' OR (mtpd.metatags_keywords
LIKE '%levi\'s%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%levi\'s%'
AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%527���%'
OR p.products_model
LIKE '%527���%'
OR m.manufacturers_name
LIKE '%527���%' OR (mtpd.metatags_keywords
LIKE '%527���%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%527���%'
AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%slim%'
OR p.products_model
LIKE '%slim%'
OR m.manufacturers_name
LIKE '%slim%' OR (mtpd.metatags_keywords
LIKE '%slim%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%slim%'
AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%boot%'
OR p.products_model
LIKE '%boot%'
OR m.manufacturers_name
LIKE '%boot%' OR (mtpd.metatags_keywords
LIKE '%boot%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%boot%'
AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%cut%'
OR p.products_model
LIKE '%cut%'
OR m.manufacturers_name
LIKE '%cut%' OR (mtpd.metatags_keywords
LIKE '%cut%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%cut%'
AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%jeans%'
OR p.products_model
LIKE '%jeans%'
OR m.manufacturers_name
LIKE '%jeans%' OR (mtpd.metatags_keywords
LIKE '%jeans%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%jeans%'
AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%walker%'
OR p.products_model
LIKE '%walker%'
OR m.manufacturers_name
LIKE '%walker%' OR (mtpd.metatags_keywords
LIKE '%walker%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%walker%'
AND mtpd.metatags_description !='')) and (pd.products_name LIKE '%r38q2581%'
OR p.products_model
LIKE '%r38q2581%'
OR m.manufacturers_name
LIKE '%r38q2581%' OR (mtpd.metatags_keywords
LIKE '%r38q2581%'
AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description
LIKE '%r38q2581%'
AND mtpd.metatags_description !='')) ))]