SELECT magazzino.magazzinolink,magazzino.annata,MAX(magazzino.id_magazzino) AS id_magazzino,vini.id_vino,vini.vino,vini.vinolink,vini.foto,vini.colore,SUM(magazzino.quantita) AS totale,MAX(magazzino.prezzovip) AS prezzovip,MAX(magazzino.prezzosito) AS prezzosito,SUM(magazzino.quantita) AS totale,magazzino.id_formato,formati_bottiglie.litri,produttori.produttore,produttori.produttorelink FROM (SELECT * FROM magazzino ORDER BY prezzosito DESC) AS magazzino,produttori,vini,formati_bottiglie WHERE vini.id_produttore=produttori.id_produttore AND vini.id_vino=magazzino.id_vino AND formati_bottiglie.id_formato=magazzino.id_formato AND (vini.id_denominazione=217) AND magazzino.instock!='3' AND magazzino.instock!='5' AND magazzino.id_magazzino NOT IN('3409','5273','5270','5275','5274','5952','8149','8145','8146','6500','6501','5954','5953','5736','5955','3056','294','979','1599','1600','5731','1598','5728','2106','7459','5958','5959','5963','5957','5962','5960','5961','3437','3036','1448','1449','3973','3985','1447','3717','1661','2418','3442','3443','3444','1445','3440','3441','3425','3424','3427','3827','3426','3730','5229','3058','3060','3063','3064','3059','3061','3062','3065','2951','2950','2952','2215','185','193','186','187','2333','188','194','3434','3435','3433','3432','3436','3447','3445','3446','3055','3054','5978','3067','3069','3066','3068','3468','3467','5981','3431','3430','3429','5737','3950','3951','3952','3948','3949','1456','3421','3422','5227','3423','3420','5989','7922','5729','8416','5562','5738','8429','1455','8043','2422','2421','1450','2420','2419','6535','6536','2684') GROUP BY magazzino.id_vino,magazzino.annata,magazzino.id_formato ORDER BY produttori.produttore,vini.vino,magazzino.annata,magazzino.id_magazzino DESC LIMIT 90,45
All Wines - TenCellars
