1267 - Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
select count(distinct p.products_id) as total from products_description pd, products_to_categories p2c, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id and s.stores_id = '4' INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where
(pd.products_name like '%Größe%' or pd.products_name like '%tuch%')
and pd.products_name like '%%'
and pd.products_name like '%%'
and (pd.products_name like '%%' or pd.products_name like '%%' or pd.products_name like '%%' or pd.products_name like '%%' or pd.products_name like '%%')
and pd.products_description like '%%'
and pd.products_name not like '%xyxy%' and pd.products_name not like '%xyxy%' and pd.products_name not like '%xyxy%' and pd.products_name not like '%xyxy%' and pd.products_name not like '%xyxy%'
and s.status = '1' and p2s.stores_id = '4' and p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2'
SALE & Restp.