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_regione=69) AND magazzino.instock!='3' AND magazzino.instock!='5' AND magazzino.id_magazzino NOT IN('111','112','2913','114','2906','119','120','121','116','117','118','2907','122','123','124','125','126','127','129','2914','131','132','133','134','135','136','137','138','139','140','141','142','146','147','148','149','150','143','145','151','152','153','154','155','7323','7315','5947','5948','3372','3371','7316','8127','1452','3982','3993','3987','22','4002','3176','1158','2233','2236','2237','2238','2239','2240','3040','3041','7167','7169','3047','5925','5926','2112','3463','1151','6388','3057','4130','1440','2415','2415','1317','1318','3972','3983','1004','2373','895','897','894','898','896','1005','1006','893','5519','1305','1306','1315','1316','1432','2323','1431','1430','2318','1437','2140','7333','1423','3096','3044','3045','3046','7329','7328','8659','1428','1426','2688','8660','8661','915','2308','8662','8663','2718','3464','8656','3465','1323','1324','1322','2665','2666','7665','7662','3968','1414','2888','2889','1301','3311','1302','1303','3466','6781','4007','3986','3969','3970','1439','1420','1291','1292','1293','7832','1300','7326','5521','5523','5522','1295','1294','1444','1434','1436','1435','1415','1304','5543','5545','5544','3039','6782','214','2227','3405','5517','3051','3048','3050','3049','6385','4219','5497','1446','3992','2324','3697','7666','2345','1321','1319','1320','1297','1298','1296','1299','2327','3469','1453','1454','807','808','3401','3400','3399','809','810','811','812','3403','3402','3404','1170','1169','6785','4303','105','2374','4304','4305','1157','2232','2230','2231','2228','2229','4225','4224','4226','6796','7207','7208','7209','4223','1417','1416','1290','1141','5977','2241','2242','5508','5509','6361','5503','3309','3303','1165','564','6797','565','1164','6798','103','1156','5599','1153','2334','1154','1154','1631','1155','1621','6801','5949','7521','6802','3140','2113','3304','5502','6803','3220','7217','7226','7228','7230','3714','3978','6390','6389','3979','5498','6397','1002','71','1003','73','72','7332','260','259','255','4003','2326','4001','2295','2325','241','242','243','4005','2423','250','249','248','247','252','251','246','245','2107','244','2108','2335','23','253','254','258','257','256','2110','2111','299','1149','7313','7309','7308','7319','1150','889','891','892','890','3310','3306','20','21','1163','1160','1161','1162','3477','3476','1159','3475') 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
