1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

select distinct p.products_id, if(s.status, s.specials_new_products_price, p.products_price) as final_price, if(p.products_quantity > 0, 1, 0) as quantity , IF(((pd.products_name) = '👉🏽'), 1, 0) as coincide_exact_nombre_0 , IF(((pd.products_name) REGEXP '[[:<:]]👉🏽[[:>:]]' = 1), 1, 0) as coincide_word_nombre_0 , IF(((pd.products_name) like '%👉🏽%'), 1, 0) as coincide_nombre_0 , IF(((m.manufacturers_name) = '👉🏽'), 1, 0) as coincide_exact_manufacturers_0 , IF(((m.manufacturers_name) like '%👉🏽%'), 1, 0) as coincide_manufacturers_0 , IF(((pr.proveedores_name) = '👉🏽'), 1, 0) as coincide_exact_proveedores_0 , IF(((pr.proveedores_name) like '%👉🏽%'), 1, 0) as coincide_proveedores_0 , IF(((pd.products_name) = 'acc6.top'), 1, 0) as coincide_exact_nombre_2 , IF(((pd.products_name) REGEXP '[[:<:]]acc6.top[[:>:]]' = 1), 1, 0) as coincide_word_nombre_2 , IF(((pd.products_name) like '%acc6.top%'), 1, 0) as coincide_nombre_2 , IF(((m.manufacturers_name) = 'acc6.top'), 1, 0) as coincide_exact_manufacturers_2 , IF(((m.manufacturers_name) like '%acc6.top%'), 1, 0) as coincide_manufacturers_2 , IF(((pr.proveedores_name) = 'acc6.top'), 1, 0) as coincide_exact_proveedores_2 , IF(((pr.proveedores_name) like '%acc6.top%'), 1, 0) as coincide_proveedores_2 , IF(((pd.products_name) = '👈🏽'), 1, 0) as coincide_exact_nombre_4 , IF(((pd.products_name) REGEXP '[[:<:]]👈🏽[[:>:]]' = 1), 1, 0) as coincide_word_nombre_4 , IF(((pd.products_name) like '%👈🏽%'), 1, 0) as coincide_nombre_4 , IF(((m.manufacturers_name) = '👈🏽'), 1, 0) as coincide_exact_manufacturers_4 , IF(((m.manufacturers_name) like '%👈🏽%'), 1, 0) as coincide_manufacturers_4 , IF(((pr.proveedores_name) = '👈🏽'), 1, 0) as coincide_exact_proveedores_4 , IF(((pr.proveedores_name) like '%👈🏽%'), 1, 0) as coincide_proveedores_4 , IF(((pd.products_name) = 'có'), 1, 0) as coincide_exact_nombre_6 , IF(((pd.products_name) REGEXP '[[:<:]]có[[:>:]]' = 1), 1, 0) as coincide_word_nombre_6 , IF(((pd.products_name) like '%có%'), 1, 0) as coincide_nombre_6 , IF(((m.manufacturers_name) = 'có'), 1, 0) as coincide_exact_manufacturers_6 , IF(((m.manufacturers_name) like '%có%'), 1, 0) as coincide_manufacturers_6 , IF(((pr.proveedores_name) = 'có'), 1, 0) as coincide_exact_proveedores_6 , IF(((pr.proveedores_name) like '%có%'), 1, 0) as coincide_proveedores_6 , IF(((pd.products_name) = 'được'), 1, 0) as coincide_exact_nombre_8 , IF(((pd.products_name) REGEXP '[[:<:]]được[[:>:]]' = 1), 1, 0) as coincide_word_nombre_8 , IF(((pd.products_name) like '%được%'), 1, 0) as coincide_nombre_8 , IF(((m.manufacturers_name) = 'được'), 1, 0) as coincide_exact_manufacturers_8 , IF(((m.manufacturers_name) like '%được%'), 1, 0) as coincide_manufacturers_8 , IF(((pr.proveedores_name) = 'được'), 1, 0) as coincide_exact_proveedores_8 , IF(((pr.proveedores_name) like '%được%'), 1, 0) as coincide_proveedores_8 , IF(((pd.products_name) = 'tài'), 1, 0) as coincide_exact_nombre_10 , IF(((pd.products_name) REGEXP '[[:<:]]tài[[:>:]]' = 1), 1, 0) as coincide_word_nombre_10 , IF(((pd.products_name) like '%tài%'), 1, 0) as coincide_nombre_10 , IF(((m.manufacturers_name) = 'tài'), 1, 0) as coincide_exact_manufacturers_10 , IF(((m.manufacturers_name) like '%tài%'), 1, 0) as coincide_manufacturers_10 , IF(((pr.proveedores_name) = 'tài'), 1, 0) as coincide_exact_proveedores_10 , IF(((pr.proveedores_name) like '%tài%'), 1, 0) as coincide_proveedores_10 , IF(((pd.products_name) = 'khoản'), 1, 0) as coincide_exact_nombre_12 , IF(((pd.products_name) REGEXP '[[:<:]]khoản[[:>:]]' = 1), 1, 0) as coincide_word_nombre_12 , IF(((pd.products_name) like '%khoản%'), 1, 0) as coincide_nombre_12 , IF(((m.manufacturers_name) = 'khoản'), 1, 0) as coincide_exact_manufacturers_12 , IF(((m.manufacturers_name) like '%khoản%'), 1, 0) as coincide_manufacturers_12 , IF(((pr.proveedores_name) = 'khoản'), 1, 0) as coincide_exact_proveedores_12 , IF(((pr.proveedores_name) like '%khoản%'), 1, 0) as coincide_proveedores_12 , IF(((pd.products_name) = 'ebpay'), 1, 0) as coincide_exact_nombre_14 , IF(((pd.products_name) REGEXP '[[:<:]]ebpay[[:>:]]' = 1), 1, 0) as coincide_word_nombre_14 , IF(((pd.products_name) like '%ebpay%'), 1, 0) as coincide_nombre_14 , IF(((m.manufacturers_name) = 'ebpay'), 1, 0) as coincide_exact_manufacturers_14 , IF(((m.manufacturers_name) like '%ebpay%'), 1, 0) as coincide_manufacturers_14 , IF(((pr.proveedores_name) = 'ebpay'), 1, 0) as coincide_exact_proveedores_14 , IF(((pr.proveedores_name) like '%ebpay%'), 1, 0) as coincide_proveedores_14 , IF(((pd.products_name) = '👉🏽 acc6.top 👈🏽 có được tài khoản ebpay'), 1, 0) as coincide_exact_nombre , IF(((pd.products_name) REGEXP '[[:<:]]👉🏽 acc6.top 👈🏽 có được tài khoản ebpay[[:>:]]' = 1), 1, 0) as coincide_word_nombre , IF(((pd.products_name) like '%👉🏽 acc6.top 👈🏽 có được tài khoản ebpay%'), 1, 0) as coincide_nombre , IF(((m.manufacturers_name) = '👉🏽 acc6.top 👈🏽 có được tài khoản ebpay'), 1, 0) as coincide_exact_manufacturers , IF(((m.manufacturers_name) like '%👉🏽 acc6.top 👈🏽 có được tài khoản ebpay%'), 1, 0) as coincide_manufacturers , IF(((pr.proveedores_name) = '👉🏽 acc6.top 👈🏽 có được tài khoản ebpay'), 1, 0) as coincide_exact_proveedores , IF(((pr.proveedores_name) like '%👉🏽 acc6.top 👈🏽 có được tài khoản ebpay%'), 1, 0) as coincide_proveedores , IF((p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]👉🏽 acc6.top 👈🏽 có được tài khoản ebpay[[:>:]]')), 1, 0) as coincide_tag from products p left join products_description pd on (p.products_id = pd.products_id and pd.language_id = '3') left join manufacturers m on (m.manufacturers_id = p.manufacturers_id) left join proveedores pr on (pr.proveedores_id = p.proveedores_id) left join specials s on (p.products_id = s.products_id and s.customers_group_id = '0') left join products_to_categories p2c on (p.products_id = p2c.products_id) where p.products_status = '1' and ((pd.products_name like '%👉🏽%' or p.products_model = '👉🏽' or m.manufacturers_name like '%👉🏽%' or pr.proveedores_name like '%👉🏽%' or pd.products_s_description like '%👉🏽%' or pd.products_description like '%👉🏽%' or (p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]👉🏽[[:>:]]'))) and (pd.products_name like '%acc6.top%' or p.products_model = 'acc6.top' or m.manufacturers_name like '%acc6.top%' or pr.proveedores_name like '%acc6.top%' or pd.products_s_description like '%acc6.top%' or pd.products_description like '%acc6.top%' or (p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]acc6.top[[:>:]]'))) and (pd.products_name like '%👈🏽%' or p.products_model = '👈🏽' or m.manufacturers_name like '%👈🏽%' or pr.proveedores_name like '%👈🏽%' or pd.products_s_description like '%👈🏽%' or pd.products_description like '%👈🏽%' or (p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]👈🏽[[:>:]]'))) and (pd.products_name like '%có%' or p.products_model = 'có' or m.manufacturers_name like '%có%' or pr.proveedores_name like '%có%' or pd.products_s_description like '%có%' or pd.products_description like '%có%' or (p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]có[[:>:]]'))) and (pd.products_name like '%được%' or p.products_model = 'được' or m.manufacturers_name like '%được%' or pr.proveedores_name like '%được%' or pd.products_s_description like '%được%' or pd.products_description like '%được%' or (p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]được[[:>:]]'))) and (pd.products_name like '%tài%' or p.products_model = 'tài' or m.manufacturers_name like '%tài%' or pr.proveedores_name like '%tài%' or pd.products_s_description like '%tài%' or pd.products_description like '%tài%' or (p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]tài[[:>:]]'))) and (pd.products_name like '%khoản%' or p.products_model = 'khoản' or m.manufacturers_name like '%khoản%' or pr.proveedores_name like '%khoản%' or pd.products_s_description like '%khoản%' or pd.products_description like '%khoản%' or (p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]khoản[[:>:]]'))) and (pd.products_name like '%ebpay%' or p.products_model = 'ebpay' or m.manufacturers_name like '%ebpay%' or pr.proveedores_name like '%ebpay%' or pd.products_s_description like '%ebpay%' or pd.products_description like '%ebpay%' or (p.products_id in (select ptpt.products_id from products_to_products_tags ptpt left join products_tags pt on (pt.products_tags_id = ptpt.products_tags_id and pt.language_id = '3') where pt.products_tags_description rlike '[[:<:]]ebpay[[:>:]]'))) ) order by quantity DESC, (coincide_exact_nombre + coincide_word_nombre + coincide_nombre + coincide_exact_manufacturers + coincide_manufacturers + coincide_proveedores + coincide_exact_proveedores + coincide_tag + coincide_exact_nombre_0 + coincide_word_nombre_0 + coincide_nombre_0 + coincide_exact_manufacturers_0 + coincide_manufacturers_0 + coincide_proveedores_0 + coincide_exact_proveedores_0 + coincide_exact_nombre_2 + coincide_word_nombre_2 + coincide_nombre_2 + coincide_exact_manufacturers_2 + coincide_manufacturers_2 + coincide_proveedores_2 + coincide_exact_proveedores_2 + coincide_exact_nombre_4 + coincide_word_nombre_4 + coincide_nombre_4 + coincide_exact_manufacturers_4 + coincide_manufacturers_4 + coincide_proveedores_4 + coincide_exact_proveedores_4 + coincide_exact_nombre_6 + coincide_word_nombre_6 + coincide_nombre_6 + coincide_exact_manufacturers_6 + coincide_manufacturers_6 + coincide_proveedores_6 + coincide_exact_proveedores_6 + coincide_exact_nombre_8 + coincide_word_nombre_8 + coincide_nombre_8 + coincide_exact_manufacturers_8 + coincide_manufacturers_8 + coincide_proveedores_8 + coincide_exact_proveedores_8 + coincide_exact_nombre_10 + coincide_word_nombre_10 + coincide_nombre_10 + coincide_exact_manufacturers_10 + coincide_manufacturers_10 + coincide_proveedores_10 + coincide_exact_proveedores_10 + coincide_exact_nombre_12 + coincide_word_nombre_12 + coincide_nombre_12 + coincide_exact_manufacturers_12 + coincide_manufacturers_12 + coincide_proveedores_12 + coincide_exact_proveedores_12 + coincide_exact_nombre_14 + coincide_word_nombre_14 + coincide_nombre_14 + coincide_exact_manufacturers_14 + coincide_manufacturers_14 + coincide_proveedores_14 + coincide_exact_proveedores_14 ) DESC, p.products_id DESC

[TEP STOP]