• SELECT ana_articoli.*, IFNULL(listini.prezzo,0) AS prezzo, (SELECT IFNULL( IF( SUM(disp sospesi) >= 1, 1, 0 ),0 ) FROM Sql1059761_4.progressivi_art WHERE id_art = ana_articoli.ID AND progressivi_art.id_mag IN (1) AND anno = 2026 ) AS disp FROM Sql1059761_4.ana_articoli LEFT JOIN Sql1059761_4.listini ON listini.id_art = ana_articoli.ID WHERE web <> 0 AND id_c1 = 2 AND id_c2 = 9 AND id_c3 = 0 AND ((listini.prezzo > 0 AND listini.id_nome_list = 1) OR ISNULL(listini.id_nome_list)) GROUP BY ana_articoli.ID ORDER BY disp DESC, descr_title
• Expression #39 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'Sql1059761_4.listini.prezzo' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

« INDIETRO