1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'

select count(p.products_id) as total from products p left join products_description pd on (p.products_id = pd.products_id) where pd.language_id = '4' and ((pd.products_name like '%f.%' or pd.products_subname like '%f.%' or pd.products_keywords like '%f.%') and (pd.products_name like '%me˙er%' or pd.products_subname like '%me˙er%' or pd.products_keywords like '%me˙er%'))

[TEP STOP]