Errore sul database di WordPress: [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,COERCIBLE) for operation '=']
SELECT SQL_CALC_FOUND_ROWS
min(v.cilindrata) as min_cilindrata,
min(v.alimentazione) as min_alim,
min(v.kw) as min_kw,
min(v.vel_max) as min_velocita,
min(v.prezzo) as min_prezzo,
min(v.co2_nedc) as min_emissioni,
min(v.consumo_medio_nedc) as min_consumo,
min(peso_potenza) as min_rapporto,
min(v.accelerazione) as min_accelerazione,
min(substring(bagagliaio, INSTR(bagagliaio,'/')+1)) as min_bagaglio,
min(v.peso) as min_peso,
max(v.cilindrata) as max_cilindrata,
max(v.alimentazione) as max_alim,
max(v.kw) as max_kw,
max(v.vel_max) as max_velocita,
max(v.prezzo) as max_prezzo,
max(v.co2_nedc) as max_emissioni,
max(v.consumo_medio_nedc) as max_consumo,
max(peso_potenza) as max_rapporto,
max(v.accelerazione) as max_accelerazione,
max(substring(bagagliaio, INSTR(bagagliaio,'/')+1)) as max_bagaglio,
max(v.peso) as max_peso,
marca, modello_finale as modello,
modello_finale as id_modello,
GROUP_CONCAT(distinct modello_finale) as modello_id,
marca as marca_id,
concat(v.carrozzeria,' ',porte,'p') as sottomodello,
group_concat(versione order by prezzo asc SEPARATOR '|') as versioni,
group_concat(v.carrozzeria order by prezzo asc SEPARATOR '|') as carrozzerie,
group_concat(porte order by prezzo asc SEPARATOR '|') as porte,
group_concat(alimentazione order by prezzo asc SEPARATOR '|') as alimentazioni,
group_concat(cilindrata order by prezzo asc SEPARATOR '|') as cilindrate,
group_concat(kw order by prezzo asc SEPARATOR '|') as kws,
group_concat(vel_max order by prezzo asc SEPARATOR '|') as velocitas,
group_concat(prezzo order by prezzo asc SEPARATOR '|') as prezzi,
group_concat(cambio order by prezzo asc SEPARATOR '|') as cambi,
group_concat(trazione order by prezzo asc SEPARATOR '|') as trazioni,
group_concat(wltp_direttiva_euro_0 order by prezzo asc SEPARATOR '|') as omologazioni,
group_concat(v.id_dbmotori order by prezzo asc SEPARATOR '|') as ids,
group_concat(distinct substring(alimentazione,1,3) order by alimentazione SEPARATOR ', ') as list_alimentazioni,
coalesce(c.posizione,10000) as posizione
FROM 2021_listino_auto v
LEFT JOIN classifica_auto c ON marca_modello = concat(marca,' ',modello_finale)
WHERE 1
AND v.carrozzeria in ('Coup��')
AND prezzo > 0
GROUP BY modello_finale
HAVING posizione IS NOT NULL
ORDER by posizione asc
LIMIT 20,10
