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_paese=9) 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','3409','3084','5535','5534','6362','3085','3086','7323','7315','5947','5948','3372','3371','7316','8127','1589','5273','5270','5275','5274','5952','8149','8145','8146','6500','6501','6502','1452','3982','3993','3987','8174','5954','5953','5736','5955','3056','294','979','1599','1600','5731','8177','1598','5728','2106','22','7459','5958','5959','5963','5957','5962','5960','5961','3437','3167','4002','3257','3036','5596','3176','1158','1448','1449','3973','3985','1447','3717','1661','2418','2233','2236','2237','2238','2239','2240','235','557','226','558','556','559','70','233','562','561','560','232','563','5734','555','229','69','68','227','1376','1377','1378','1379','3253','1346','1347','1348','1349','2656','2657','4207','4206','7155','7160','1374','5563','2720','1365','1366','1389','1390','1367','1364','6758','74','4208','3461','2361','3283','1375','1355','1137','3875','1138','6759','1350','1979','1146','7610','8086','8085','2670','1978','1330','1331','4209','174','2957','1868','3313','1289','234','6832','4201','3040','3041','7164','4210','7167','7169','1135','8109','6761','3047','6349','6350','1270','1370','1371','1372','8094','5944','1380','1381','1382','1383','1384','6763','178','180','3307','1645','3748','6764','1391','1345','1333','6765','2659','2661','2660','5940','5941','4212','5903','2663','2664','1136','1144','3279','3178','1143','2658','3278','1689','3300','3275','3299','1198','2362','6767','5910','2672','3876','1359','1340','1341','2687','4213','3462','2360','1342','1343','1344','4214','1368','1369','3315','1393','5902','5943','1336','5945','1337','3314','2667','2668','961','3316','1682','2363','1357','1358','954','946','8353','181','182','1413','1325','1326','1327','1328','1329','8083','2364','1338','1339','960','3312','4215','4216','2662','1338','555','2671','1360','1361','1362','4217','1386','1387','1388','7196','7197','7198','1692','1354','8088','1334','1335','8093','8099','8103','5946','1695','1993','6769','1351','1352','1353','1363','1140','1199','1148','1356','1147','3077','3408','6770','8081','8089','3256','3292','3276','1373','8100','1142','3442','3443','3444','3258','5463','5464','2328','5925','5926','2112','3463','7349','7626','3182','3183','3184','3185','3186','167','2336','2337','168','169','3053','3082','3083','102','1622','1151','1445','6388','3440','3441','7647','1422','6356','6358','6359','3057','4130','1440','2415','2415','1317','1318','3972','3983','1004','2373','895','897','894','898','896','1005','1006','893','5519','5971','8233','1305','1306','2004','1315','1316','1432','2323','1431','1430','2318','1437','2140','7333','4218','1423','7652','3096','3044','3045','3046','3188','3087','7329','7328','8659','1428','1426','2688','8660','8661','915','2308','8662','8663','3336','1166','1167','1168','293','3080','5530','3079','3078','5531','3335','2718','2946','2945','5461','3464','8656','3465','7654','7656','3264','1323','1324','1322','2665','2666','7665','7662','3968','1414','2888','2889','1301','3311','1302','1303','3466','6781','1421','6366','5482','6368','5479','5480','3091','3090','5484','6371','6372','3089','3092','6365','4007','3986','3969','3970','5485','5487','5489','1439','1420','1291','1292','1293','7832','1300','7326','5521','5523','5522','6373','6374','6376','1976','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','813','3406','5557','3531','1321','1319','1320','2319','1419','2003','1297','1298','1296','6783','1299','5745','2327','3469','1453','1454','807','808','3401','3400','3399','809','810','811','812','3403','3402','3404','1170','1169','6784','6403','6404','6405','6406','6785','5496','8486','8234','1273','3425','3424','3427','3827','3426','3730','5229','5757','2860','4303','105','2374','4304','4305','3058','3060','3063','3064','3059','3061','3062','1157','2232','2230','2231','2228','2229','3065','7527','7528','3075','3071','3072','3074','3073','3070','5527','5526','3205','8257','8260','4137','4133','4134','4135','1172','2009','1173','4138','4225','4224','4226','6796','7207','7208','7209','4223','1417','1416','1290','2951','2950','2952','2215','185','193','186','187','2333','188','194','3434','3435','3433','3432','3436','3447','3445','3446','1141','3352','3055','3054','5977','5978','3067','3069','3066','3068','2241','2242','5508','5509','6361','5503','3309','3303','1139','1438','1165','564','6797','565','1164','6798','3468','3467','3326','3327','3328','2352','2351','7339','7338','2806','1152','4338','7340','103','1145','5981','3431','3430','3429','3892','5492','3208','3209','1156','2947','2948','2355','5599','1153','2334','1154','1154','1631','1155','1621','6801','5949','7521','6802','3140','1683','5982','2113','3524','3525','1696','1691','1697','5737','2002','5983','3252','4919','3950','3951','3952','3948','3949','1456','3304','1200','5984','5502','3334','7534','7535','3421','3422','5227','3423','3420','6803','1418','3220','7217','7224','7225','7226','7228','7230','3714','3978','6390','6389','3979','5498','6397','5989','2005','4112','7922','3221','4229','1392','956','2139','228','5729','3499','3496','3501','2862','3492','3500','3493','3495','3498','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','8416','3351','299','5562','5738','1149','7313','7309','7308','7319','1150','889','891','892','890','3310','3306','8429','8232','1455','1433','2375','2878','8043','2422','2421','1450','2420','2419','6408','6407','6535','6536','2684','7831','8078','8077','20','21','1163','1160','1161','1162','3477','3476','1159','3475','5537','5536','3081','5490') 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
Free delivery in HK over
HK$1,500
Whatsapp or Wechat
+852 5965 4763
Free delivery in HK over
HK$1,500
Welcome, Guest

All Wines

456 wines
Sort by
Diane de Belgrave 1998 Château Belgrave photo

Château Belgrave

Diane de Belgrave 1998

HK$290.00
Haut-Médoc 1982 Château Belgrave photo

Château Belgrave

Haut-Médoc 1982

HK$850.00
Haut-Médoc 1992 Château Belgrave photo

Château Belgrave

Haut-Médoc 1992

HK$380.00
Belle Brise 1996 Château Belle Brise photo

Château Belle Brise

Belle Brise 1996

HK$950.00
Belle Brise 1998 Château Belle Brise photo

Château Belle Brise

Belle Brise 1998

HK$980.00
Belle Brise 1999 Magnum Château Belle Brise photo

Château Belle Brise

Belle Brise 1999

HK$1,980.00
Belle Brise 1999 Château Belle Brise photo

Château Belle Brise

Belle Brise 1999

HK$950.00
Madiran Vieilles Vignes 2008 Château Bouscassé photo

Château Bouscassé

Madiran Vieilles Vignes 2008

HK$360.00
Madiran Vieilles Vignes 2010 Château Bouscassé photo

Château Bouscassé

Madiran Vieilles Vignes 2010

HK$380.00
Saint-Estèphe 1979 Château Capbern Gasqueton photo

Château Capbern Gasqueton

Saint-Estèphe 1979

HK$450.00
Certan Marzelle 2007 Château Certan Marzelle photo

Château Certan Marzelle

Certan Marzelle 2007

HK$350.00
Cos d'Estournel 1990 Château Cos d'Estournel photo

Château Cos d'Estournel

Cos d'Estournel 1990

HK$1,980.00
Cos d'Estournel 1999 Château Cos d'Estournel photo

Château Cos d'Estournel

Cos d'Estournel 1999

HK$1,280.00
Cos d'Estournel 2000 Château Cos d'Estournel photo

Château Cos d'Estournel

Cos d'Estournel 2000

HK$1,980.00
Cos d'Estournel 2001 Château Cos d'Estournel photo

Château Cos d'Estournel

Cos d'Estournel 2001

HK$1,280.00
d'Angludet 1999 Château d'Angludet photo

Château d'Angludet

d'Angludet 1999

HK$450.00
Haut-Médoc 1985 Château d'Arche photo

Château d'Arche

Haut-Médoc 1985

HK$380.00
Graves 1996 Château d'Ardennes photo

Château d'Ardennes

Graves 1996

HK$290.00
Graves 2009 Château d'Ardennes photo

Château d'Ardennes

Graves 2009

HK$230.00
Graves 2010 Château d'Ardennes photo

Château d'Ardennes

Graves 2010

HK$240.00
Graves 2011 Château d'Ardennes photo

Château d'Ardennes

Graves 2011

HK$220.00
Whispering Angel 2021 Château d'Esclans photo

Château d'Esclans

Whispering Angel 2021

HK$160.00
Sauternes 2001 0.375L Château d'Yquem photo

Château d'Yquem

Sauternes 2001

HK$2,380.00
Pessac-Léognan Blanc 1990 Château de Fieuzal photo

Château de Fieuzal

Pessac-Léognan Blanc 1990

HK$780.00
Grand Roussillon 2002 0.5L Château de Jau photo

Château de Jau

Grand Roussillon 2002

HK$330.00
Muscat de Rivesaltes 2006 0.5L Château de Jau photo

Château de Jau

Muscat de Rivesaltes 2006

HK$220.00
Clos de Vougeot Vieilles Vignes 2012 Château de la Tour photo
HK$1,730.00
Beaune 1981 Château de Meursault photo

Château de Meursault

Beaune 1981

HK$480.00
Beaune 1er Cru 1983 Château de Meursault photo

Château de Meursault

Beaune 1er Cru 1983

HK$690.00
Clos du Château Bourgogne Chardonnay 2004 Château de Meursault photo
HK$380.00
Pinot Noir du Château 1985 Château de Meursault photo

Château de Meursault

Pinot Noir du Château 1985

HK$395.00
Pommard Clos des Épenots 1981 Château de Meursault photo

Château de Meursault

Pommard Clos des Épenots 1981

HK$1,650.00
Savigny du Domaine 1983 Château de Meursault photo

Château de Meursault

Savigny du Domaine 1983

HK$530.00
Volnay Clos des Chènes 1982 Château de Meursault photo

Château de Meursault

Volnay Clos des Chènes 1982

HK$980.00
De Pez 1998 Château de Pez photo

Château de Pez

De Pez 1998

HK$580.00
De Pez 1999 Château de Pez photo

Château de Pez

De Pez 1999

HK$330.00
De Pez 2002 Château de Pez photo

Château de Pez

De Pez 2002

HK$450.00
De Pez 2004 Magnum Château de Pez photo

Château de Pez

De Pez 2004

HK$980.00
De Pez 2004 Château de Pez photo

Château de Pez

De Pez 2004

HK$450.00
De Pez 2005 Magnum Château de Pez photo

Château de Pez

De Pez 2005

HK$1,880.00
Bandol 1993 Château de Pibarnon photo

Château de Pibarnon

Bandol 1993

HK$880.00
Sauternes 2001 Château de Rolland photo

Château de Rolland

Sauternes 2001

HK$380.00
Sauternes 2002 Château de Rolland photo

Château de Rolland

Sauternes 2002

HK$280.00
Sauternes 2003 Château de Rolland photo

Château de Rolland

Sauternes 2003

HK$300.00
Clos De L'Hermitage 2001 Château de Ségriès photo

Château de Ségriès

Clos De L'Hermitage 2001

HK$360.00