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 '%cathédrale%' or pd.products_subname like '%cathédrale%' or pd.products_keywords like '%cathédrale%') and (pd.products_name like '%notre%' or pd.products_subname like '%notre%' or pd.products_keywords like '%notre%') and (pd.products_name like '%dame%' or pd.products_subname like '%dame%' or pd.products_keywords like '%dame%') and (pd.products_name like '%senlis%' or pd.products_subname like '%senlis%' or pd.products_keywords like '%senlis%'))

[TEP STOP]