SELECT ana_articoli.*,
(SELECT
IFNULL(
IF(
SUM(disp+sospesi) >= 1, 1, 0
),0
)
FROM Sql1126085_1.progressivi_art WHERE id_art = ana_articoli.ID AND progressivi_art.id_mag IN (1,11,12) AND anno = 2020
) AS disp FROM Sql1126085_1.ana_articoli WHERE web <> 0 AND id_c1 = 61 AND id_c2 = 1115 AND id_c3 = 0 AND ana_articoli.ID IN (SELECT id_art FROM Sql1126085_1.listini WHERE id_nome_list = 1 AND prezzo > 0) GROUP BY ana_articoli.ID ORDER BY disp DESC, descr_title
