SELECT * FROM operatori,op_ap,offerte WHERE operatori.paginaospitale <> '0' AND operatori.progressivooperatore = op_ap.id_operatori AND operatori.progressivooperatore = offerte.codicestruttura AND offerte.dal <= '2024-04-31' AND offerte.al >= '2024-04-25' GROUP BY operatori.progressivooperatore ORDER BY operatori.CAP, operatori.kcomune, operatori.tipologia, offerte.dal ASC, offerte.alExpression #59 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'soggiorni.op_ap.id_ap' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by