1267 Illegal mix of collations (ujis_japanese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
in:
[SELECT DISTINCT p.products_image, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter FROM (cnu_products p LEFT JOIN cnu_manufacturers m USING(manufacturers_id), cnu_products_description pd, cnu_categories c, cnu_products_to_categories p2c LEFT JOIN cnu_meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 2 ) WHERE p.products_status = 1 AND p.products_id = pd.products_id AND p.master_categories_id != 6 AND p.master_categories_id != 490 AND pd.language_id = 2 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND( p.products_model NOT LIKE '%-_.__' AND p.products_model NOT LIKE '%cm' AND p.products_model NOT LIKE '%-F' AND p.products_model NOT LIKE '%-XS' AND p.products_model NOT LIKE '%-S' AND p.products_model NOT LIKE '%-M' AND p.products_model NOT LIKE '%-L' AND p.products_model NOT LIKE '%-XL' AND p.products_model NOT LIKE '%-XXL' AND p.products_model NOT LIKE '%-S_M' AND p.products_model NOT LIKE '%-L_XL' AND p.products_model NOT LIKE '%-A' AND p.products_model NOT LIKE '%-B' AND p.products_model NOT LIKE '%-C' AND p.products_model NOT LIKE '%_bou-%' AND p.products_model NOT LIKE 'number_ironsheet_set-%' AND p.products_model NOT LIKE 'necktie_01-%' AND p.products_model NOT LIKE 'ribbon_tie-%' AND p.products_model NOT LIKE 'ribbontie_stripe-%' AND p.products_model NOT LIKE 'chou_necktie-%' AND p.products_model NOT LIKE 'necktie_01-%' ) AND ((pd.products_name LIKE '%new������������������%' OR p.products_model LIKE '%new������������������%' OR m.manufacturers_name LIKE '%new������������������%' OR (mtpd.metatags_keywords LIKE '%new������������������%' AND mtpd.metatags_keywords !='') OR (p.products_id = 'new������������������' ) OR (mtpd.metatags_description LIKE '%new������������������%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%new������������������%') ) order by p.products_sort_order, pd.products_name]