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) = 'obter'), 1, 0) as coincide_exact_nombre_0 , IF(((pd.products_name) REGEXP '[[:<:]]obter[[:>:]]' = 1), 1, 0) as coincide_word_nombre_0 , IF(((pd.products_name) like '%obter%'), 1, 0) as coincide_nombre_0 , IF(((m.manufacturers_name) = 'obter'), 1, 0) as coincide_exact_manufacturers_0 , IF(((m.manufacturers_name) like '%obter%'), 1, 0) as coincide_manufacturers_0 , IF(((pr.proveedores_name) = 'obter'), 1, 0) as coincide_exact_proveedores_0 , IF(((pr.proveedores_name) like '%obter%'), 1, 0) as coincide_proveedores_0 , IF(((pd.products_name) = 'uma'), 1, 0) as coincide_exact_nombre_2 , IF(((pd.products_name) REGEXP '[[:<:]]uma[[:>:]]' = 1), 1, 0) as coincide_word_nombre_2 , IF(((pd.products_name) like '%uma%'), 1, 0) as coincide_nombre_2 , IF(((m.manufacturers_name) = 'uma'), 1, 0) as coincide_exact_manufacturers_2 , IF(((m.manufacturers_name) like '%uma%'), 1, 0) as coincide_manufacturers_2 , IF(((pr.proveedores_name) = 'uma'), 1, 0) as coincide_exact_proveedores_2 , IF(((pr.proveedores_name) like '%uma%'), 1, 0) as coincide_proveedores_2 , IF(((pd.products_name) = 'conta'), 1, 0) as coincide_exact_nombre_4 , IF(((pd.products_name) REGEXP '[[:<:]]conta[[:>:]]' = 1), 1, 0) as coincide_word_nombre_4 , IF(((pd.products_name) like '%conta%'), 1, 0) as coincide_nombre_4 , IF(((m.manufacturers_name) = 'conta'), 1, 0) as coincide_exact_manufacturers_4 , IF(((m.manufacturers_name) like '%conta%'), 1, 0) as coincide_manufacturers_4 , IF(((pr.proveedores_name) = 'conta'), 1, 0) as coincide_exact_proveedores_4 , IF(((pr.proveedores_name) like '%conta%'), 1, 0) as coincide_proveedores_4 , IF(((pd.products_name) = 'de'), 1, 0) as coincide_exact_nombre_6 , IF(((pd.products_name) REGEXP '[[:<:]]de[[:>:]]' = 1), 1, 0) as coincide_word_nombre_6 , IF(((pd.products_name) like '%de%'), 1, 0) as coincide_nombre_6 , IF(((m.manufacturers_name) = 'de'), 1, 0) as coincide_exact_manufacturers_6 , IF(((m.manufacturers_name) like '%de%'), 1, 0) as coincide_manufacturers_6 , IF(((pr.proveedores_name) = 'de'), 1, 0) as coincide_exact_proveedores_6 , IF(((pr.proveedores_name) like '%de%'), 1, 0) as coincide_proveedores_6 , IF(((pd.products_name) = 'membro'), 1, 0) as coincide_exact_nombre_8 , IF(((pd.products_name) REGEXP '[[:<:]]membro[[:>:]]' = 1), 1, 0) as coincide_word_nombre_8 , IF(((pd.products_name) like '%membro%'), 1, 0) as coincide_nombre_8 , IF(((m.manufacturers_name) = 'membro'), 1, 0) as coincide_exact_manufacturers_8 , IF(((m.manufacturers_name) like '%membro%'), 1, 0) as coincide_manufacturers_8 , IF(((pr.proveedores_name) = 'membro'), 1, 0) as coincide_exact_proveedores_8 , IF(((pr.proveedores_name) like '%membro%'), 1, 0) as coincide_proveedores_8 , IF(((pd.products_name) = 'ipsos'), 1, 0) as coincide_exact_nombre_10 , IF(((pd.products_name) REGEXP '[[:<:]]ipsos[[:>:]]' = 1), 1, 0) as coincide_word_nombre_10 , IF(((pd.products_name) like '%ipsos%'), 1, 0) as coincide_nombre_10 , IF(((m.manufacturers_name) = 'ipsos'), 1, 0) as coincide_exact_manufacturers_10 , IF(((m.manufacturers_name) like '%ipsos%'), 1, 0) as coincide_manufacturers_10 , IF(((pr.proveedores_name) = 'ipsos'), 1, 0) as coincide_exact_proveedores_10 , IF(((pr.proveedores_name) like '%ipsos%'), 1, 0) as coincide_proveedores_10 , IF(((pd.products_name) = 'isay'), 1, 0) as coincide_exact_nombre_12 , IF(((pd.products_name) REGEXP '[[:<:]]isay[[:>:]]' = 1), 1, 0) as coincide_word_nombre_12 , IF(((pd.products_name) like '%isay%'), 1, 0) as coincide_nombre_12 , IF(((m.manufacturers_name) = 'isay'), 1, 0) as coincide_exact_manufacturers_12 , IF(((m.manufacturers_name) like '%isay%'), 1, 0) as coincide_manufacturers_12 , IF(((pr.proveedores_name) = 'isay'), 1, 0) as coincide_exact_proveedores_12 , IF(((pr.proveedores_name) like '%isay%'), 1, 0) as coincide_proveedores_12 , IF(((pd.products_name) = '👉🏿'), 1, 0) as coincide_exact_nombre_14 , IF(((pd.products_name) REGEXP '[[:<:]]👉🏿[[:>:]]' = 1), 1, 0) as coincide_word_nombre_14 , IF(((pd.products_name) like '%👉🏿%'), 1, 0) as coincide_nombre_14 , IF(((m.manufacturers_name) = '👉🏿'), 1, 0) as coincide_exact_manufacturers_14 , IF(((m.manufacturers_name) like '%👉🏿%'), 1, 0) as coincide_manufacturers_14 , IF(((pr.proveedores_name) = '👉🏿'), 1, 0) as coincide_exact_proveedores_14 , IF(((pr.proveedores_name) like '%👉🏿%'), 1, 0) as coincide_proveedores_14 , IF(((pd.products_name) = 'acc6.top'), 1, 0) as coincide_exact_nombre_16 , IF(((pd.products_name) REGEXP '[[:<:]]acc6.top[[:>:]]' = 1), 1, 0) as coincide_word_nombre_16 , IF(((pd.products_name) like '%acc6.top%'), 1, 0) as coincide_nombre_16 , IF(((m.manufacturers_name) = 'acc6.top'), 1, 0) as coincide_exact_manufacturers_16 , IF(((m.manufacturers_name) like '%acc6.top%'), 1, 0) as coincide_manufacturers_16 , IF(((pr.proveedores_name) = 'acc6.top'), 1, 0) as coincide_exact_proveedores_16 , IF(((pr.proveedores_name) like '%acc6.top%'), 1, 0) as coincide_proveedores_16 , IF(((pd.products_name) = '👈🏿'), 1, 0) as coincide_exact_nombre_18 , IF(((pd.products_name) REGEXP '[[:<:]]👈🏿[[:>:]]' = 1), 1, 0) as coincide_word_nombre_18 , IF(((pd.products_name) like '%👈🏿%'), 1, 0) as coincide_nombre_18 , IF(((m.manufacturers_name) = '👈🏿'), 1, 0) as coincide_exact_manufacturers_18 , IF(((m.manufacturers_name) like '%👈🏿%'), 1, 0) as coincide_manufacturers_18 , IF(((pr.proveedores_name) = '👈🏿'), 1, 0) as coincide_exact_proveedores_18 , IF(((pr.proveedores_name) like '%👈🏿%'), 1, 0) as coincide_proveedores_18 , IF(((pd.products_name) = 'obter uma conta de membro ipsos isay 👉🏿 acc6.top 👈🏿'), 1, 0) as coincide_exact_nombre , IF(((pd.products_name) REGEXP '[[:<:]]obter uma conta de membro ipsos isay 👉🏿 acc6.top 👈🏿[[:>:]]' = 1), 1, 0) as coincide_word_nombre , IF(((pd.products_name) like '%obter uma conta de membro ipsos isay 👉🏿 acc6.top 👈🏿%'), 1, 0) as coincide_nombre , IF(((m.manufacturers_name) = 'obter uma conta de membro ipsos isay 👉🏿 acc6.top 👈🏿'), 1, 0) as coincide_exact_manufacturers , IF(((m.manufacturers_name) like '%obter uma conta de membro ipsos isay 👉🏿 acc6.top 👈🏿%'), 1, 0) as coincide_manufacturers , IF(((pr.proveedores_name) = 'obter uma conta de membro ipsos isay 👉🏿 acc6.top 👈🏿'), 1, 0) as coincide_exact_proveedores , IF(((pr.proveedores_name) like '%obter uma conta de membro ipsos isay 👉🏿 acc6.top 👈🏿%'), 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 '[[:<:]]obter uma conta de membro ipsos isay 👉🏿 acc6.top 👈🏿[[:>:]]')), 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 '%obter%' or p.products_model = 'obter' or m.manufacturers_name like '%obter%' or pr.proveedores_name like '%obter%' or pd.products_s_description like '%obter%' or pd.products_description like '%obter%' 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 '[[:<:]]obter[[:>:]]'))) and (pd.products_name like '%uma%' or p.products_model = 'uma' or m.manufacturers_name like '%uma%' or pr.proveedores_name like '%uma%' or pd.products_s_description like '%uma%' or pd.products_description like '%uma%' 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 '[[:<:]]uma[[:>:]]'))) and (pd.products_name like '%conta%' or p.products_model = 'conta' or m.manufacturers_name like '%conta%' or pr.proveedores_name like '%conta%' or pd.products_s_description like '%conta%' or pd.products_description like '%conta%' 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 '[[:<:]]conta[[:>:]]'))) and (pd.products_name like '%de%' or p.products_model = 'de' or m.manufacturers_name like '%de%' or pr.proveedores_name like '%de%' or pd.products_s_description like '%de%' or pd.products_description like '%de%' 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 '[[:<:]]de[[:>:]]'))) and (pd.products_name like '%membro%' or p.products_model = 'membro' or m.manufacturers_name like '%membro%' or pr.proveedores_name like '%membro%' or pd.products_s_description like '%membro%' or pd.products_description like '%membro%' 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 '[[:<:]]membro[[:>:]]'))) and (pd.products_name like '%ipsos%' or p.products_model = 'ipsos' or m.manufacturers_name like '%ipsos%' or pr.proveedores_name like '%ipsos%' or pd.products_s_description like '%ipsos%' or pd.products_description like '%ipsos%' 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 '[[:<:]]ipsos[[:>:]]'))) and (pd.products_name like '%isay%' or p.products_model = 'isay' or m.manufacturers_name like '%isay%' or pr.proveedores_name like '%isay%' or pd.products_s_description like '%isay%' or pd.products_description like '%isay%' 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 '[[:<:]]isay[[:>:]]'))) 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 '[[:<:]]👈🏿[[:>:]]'))) ) 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 + coincide_exact_nombre_16 + coincide_word_nombre_16 + coincide_nombre_16 + coincide_exact_manufacturers_16 + coincide_manufacturers_16 + coincide_proveedores_16 + coincide_exact_proveedores_16 + coincide_exact_nombre_18 + coincide_word_nombre_18 + coincide_nombre_18 + coincide_exact_manufacturers_18 + coincide_manufacturers_18 + coincide_proveedores_18 + coincide_exact_proveedores_18 ) DESC, p.products_id DESC

[TEP STOP]