344 097 3162

COVER SMARTPHONE >> Motorola

Array
(
)
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 = 1079 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