1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'
select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '144' or p2c.categories_id = '145' or p2c.categories_id = '146' or p2c.categories_id = '147' or p2c.categories_id = '154' or p2c.categories_id = '155' or p2c.categories_id = '225' or p2c.categories_id = '305' or p2c.categories_id = '475' or p2c.categories_id = '476' or p2c.categories_id = '477' or p2c.categories_id = '478' or p2c.categories_id = '148' or p2c.categories_id = '150' or p2c.categories_id = '152' or p2c.categories_id = '199' or p2c.categories_id = '201' or p2c.categories_id = '205' or p2c.categories_id = '206' or p2c.categories_id = '217' or p2c.categories_id = '246' or p2c.categories_id = '227' or p2c.categories_id = '230' or p2c.categories_id = '231' or p2c.categories_id = '232' or p2c.categories_id = '237' or p2c.categories_id = '238' or p2c.categories_id = '240' or p2c.categories_id = '241' or p2c.categories_id = '242' or p2c.categories_id = '243' or p2c.categories_id = '228' or p2c.categories_id = '233' or p2c.categories_id = '234' or p2c.categories_id = '235' or p2c.categories_id = '236' or p2c.categories_id = '245' or p2c.categories_id = '244' or p2c.categories_id = '248' or p2c.categories_id = '249' or p2c.categories_id = '252' or p2c.categories_id = '254' or p2c.categories_id = '255' or p2c.categories_id = '256' or p2c.categories_id = '257' or p2c.categories_id = '258' or p2c.categories_id = '259' or p2c.categories_id = '260' or p2c.categories_id = '261' or p2c.categories_id = '262' or p2c.categories_id = '263' or p2c.categories_id = '264' or p2c.categories_id = '265' or p2c.categories_id = '266' or p2c.categories_id = '268' or p2c.categories_id = '269' or p2c.categories_id = '270' or p2c.categories_id = '271' or p2c.categories_id = '272' or p2c.categories_id = '273' or p2c.categories_id = '274' or p2c.categories_id = '275' or p2c.categories_id = '457' or p2c.categories_id = '253' or p2c.categories_id = '458' or p2c.categories_id = '226' or p2c.categories_id = '459' or p2c.categories_id = '479' or p2c.categories_id = '480' or p2c.categories_id = '481') and m.manufacturers_id = '17' and ((pd.products_name like '%ausführung%' or p.products_model like '%ausführung%' or m.manufacturers_name like '%ausführung%') and (pd.products_name like '%lasiert%' or p.products_model like '%lasiert%' or m.manufacturers_name like '%lasiert%') )order by p.products_price asc