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 '%ain%' or pd.products_subname like '%ain%' or pd.products_keywords like '%ain%') and (pd.products_name like '%rhône%' or pd.products_subname like '%rhône%' or pd.products_keywords like '%rhône%') and (pd.products_name like '%alpes%' or pd.products_subname like '%alpes%' or pd.products_keywords like '%alpes%'))

[TEP STOP]