1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'
select count(p.products_id) as total from products_description pd, products p left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_master = '0' and p.products_listing_status = '1' AND p.products_date_added < '2025-02-05 02:48:30' and p.products_id = p2c.products_id and (pd.products_name like '0%' || pd.products_name like '1%' || pd.products_name like '�%' || pd.products_name like '�%' || pd.products_name like '2%' || pd.products_name like '3%' || pd.products_name like '4%' || pd.products_name like '5%' || pd.products_name like '6%' || pd.products_name like '7%' || pd.products_name like '8%' || pd.products_name like '9%') and pd.products_id = p2c.products_id and pd.language_id = '3' and p2c.categories_id = '14'