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.colore=0) AND magazzino.instock!='3' AND magazzino.instock!='5' AND magazzino.id_magazzino NOT IN('1190','7323','7315','5947','5948','3372','3371','7316','8127','7240','1589','5608','5650','8137','8133','8134','8135','5764','3152','4556','4555','2063','4538','4539','4540','4516','4522','4524','4523','2365','4795','6087','1452','3982','3993','22','5779','4099','4101','4100','3358','3357','3393','3392','6506','1130','3458','4823','4108','1937','1932','4264','4263','4265','6513','4002','1992','1995','5680','8210','3349','6068','6515','4113','2233','2236','2237','2238','2239','7167','7169','3047','6349','6350','1993','3077','839','3340','6771','6516','5925','5926','2112','3463','6317','4419','4420','7349','2873','6772','7496','1622','5968','5966','5969','6079','6078','1151','6388','7647','1055','6356','6358','6359','3057','3983','1004','5971','8233','1305','1306','1437','2140','7333','7329','7328','1168','3080','5530','2946','2945','2888','2889','1301','1302','1303','1421','6366','5482','5479','5480','4007','3986','1420','1291','1292','1293','7832','1300','7326','6373','6374','6376','1295','1294','1415','1304','5543','5545','5544','214','2227','3405','5517','3051','3048','3050','3049','6385','5497','1446','3992','2324','3697','2345','1297','1298','1296','6783','1299','5745','807','808','3401','3400','3399','809','810','811','812','3403','3402','3404','6784','6403','6404','6405','6406','6785','8486','8234','3571','6043','3574','1193','1194','5757','4300','2078','3417','3418','2860','8240','6787','7307','5773','1157','2230','2231','2228','2229','6791','1269','1053','1131','7244','4319','1674','3653','5707','7239','3075','3071','3072','3074','3073','3070','2086','2082','5627','6519','6520','3899','3900','2879','2077','2109','297','2074','2075','2076','2973','8260','2009','3601','3609','1417','1416','4422','4423','6067','5452','769','6523','1653','3905','3906','5771','2241','2242','5508','5509','6361','5503','5785','8296','6847','3581','3583','5756','8648','5328','3916','3999','2092','7339','7338','2806','1152','4338','7340','5597','5750','1156','8334','4340','4341','4615','2846','2845','2334','1154','1154','1631','1155','6801','7521','2113','3107','3524','1696','1691','1697','3933','5763','6853','2002','1112','5783','5782','1111','2035','5637','988','989','990','6228','6731','991','992','1106','6232','6737','997','998','999','993','994','995','996','1105','1104','1000','6230','2056','1129','5502','1132','3334','7534','7535','8393','366','983','2523','2526','2541','820','3553','1418','3714','3978','6390','6389','3979','5498','6397','3499','3496','3501','2862','3492','3500','3493','3495','3498','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','2042','2043','5760','2044','5766','8667','5744','8668','5992','5994','1149','7313','7309','7308','7319','1150','889','891','892','890','8434','3818','3939','2036','8438','7259','6872','6092','1931','1974','1962','3242','4587','4588','6101','3998','3945','4127','4125','4126','4128','7567','4122','4123','4394','4124','1127','7568','1126','4119','4121','4120','4395','4396','1128','4129','4397','2305','2138','8624','2304','2302','2322','2303','3628','5776','4786','1930','4398','1929','7545','7546','6408','6407','8612','4602','4603','4606','5923','2285','2286','2287','2288','8475','3503','3502','7280','7281','7275','7257','7256','7264','7265','4748','6071','4750','6072','4749','6074','7551','3925','3996','7548','7549','7550','3380','3381','20','21','1163','1160','1161','1162','3477','3476','1159','3475','1133','2096','3701','3702','3703','1065','1064','4426','4425','5815','4424','3350','5996','2583') GROUP BY magazzino.id_vino,magazzino.annata,magazzino.id_formato ORDER BY produttori.produttore,vini.vino,magazzino.annata,magazzino.id_magazzino DESC LIMIT 0,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

684 wines
Sort by
Leukò 2018 A Vita photo

A Vita

Leukò 2018

HK$160.00
Leukò 2021 A Vita photo

A Vita

Leukò 2021

HK$155.00
Gewürztraminer 2018 Abbazia di Novacella photo

Abbazia di Novacella

Gewürztraminer 2018

HK$175.00
Gewürztraminer Praepositus 2017 Abbazia di Novacella photo

Abbazia di Novacella

Gewürztraminer Praepositus 2017

HK$195.00
Gewürztraminer Praepositus 2018 Abbazia di Novacella photo

Abbazia di Novacella

Gewürztraminer Praepositus 2018

HK$195.00
Kerner Praepositus 2017 Abbazia di Novacella photo

Abbazia di Novacella

Kerner Praepositus 2017

HK$195.00
Kerner Praepositus 2018 Abbazia di Novacella photo

Abbazia di Novacella

Kerner Praepositus 2018

HK$195.00
Sauvignon Praepositus 2016 Abbazia di Novacella photo

Abbazia di Novacella

Sauvignon Praepositus 2016

HK$195.00
Sauvignon Praepositus 2017 Abbazia di Novacella photo

Abbazia di Novacella

Sauvignon Praepositus 2017

HK$195.00
Sauvignon Praepositus 2018 Abbazia di Novacella photo

Abbazia di Novacella

Sauvignon Praepositus 2018

HK$195.00
Vermentino 2017 Agricoltori del Chianti Geografico photo

Agricoltori del Chianti Geografico

Vermentino 2017

HK$160.00
Chablis 1er Cru 2002 Albert Pic photo
HK$650.00
Petit Chablis 2008 Albert Pic photo

Albert Pic

Petit Chablis 2008

HK$240.00
Bussiador 2001 Aldo Conterno photo

Aldo Conterno

Bussiador 2001

HK$680.00
Coda di Volpe 2018 Amarano photo
HK$130.00
Chardonnay 2021 Anselmet photo

Anselmet

Chardonnay 2021

HK$200.00
Gewürztraminer Rutter 2015 Ansitz Pfitscher photo

Ansitz Pfitscher

Gewürztraminer Rutter 2015

HK$250.00
Bramito del Cervo 2017 Antinori photo
HK$165.00
Cervaro della Sala 2001 0.375L Antinori photo
HK$450.00
Cervaro della Sala 2002 0.375L Antinori photo
HK$380.00
Bianco Cicinis 2001 Attems photo
HK$250.00
Bianco Cicinis 2006 Attems photo
HK$250.00
Ribolla Gialla 2016 Attems photo
HK$135.00
Sauvignon 2007 Attems photo
HK$160.00
Falanghina 2017 Azienda Agricola San Salvatore photo

Azienda Agricola San Salvatore

Falanghina 2017

HK$175.00
Greco di Tufo 2010 Magnum Bambinuto photo

Bambinuto

Greco di Tufo 2010

HK$475.00
Greco di Tufo 2011 Magnum Bambinuto photo

Bambinuto

Greco di Tufo 2011

HK$440.00
Greco di Tufo 2012 Magnum Bambinuto photo

Bambinuto

Greco di Tufo 2012

HK$440.00
Greco di Tufo 2014 Magnum Bambinuto photo

Bambinuto

Greco di Tufo 2014

HK$440.00
Greco di Tufo 2014 Bambinuto photo

Bambinuto

Greco di Tufo 2014

HK$210.00
Greco di Tufo 2015 Bambinuto photo

Bambinuto

Greco di Tufo 2015

HK$195.00
Greco di Tufo 2016 Bambinuto photo

Bambinuto

Greco di Tufo 2016

HK$200.00
Greco di Tufo 2018 Bambinuto photo

Bambinuto

Greco di Tufo 2018

HK$175.00
Greco di Tufo Picoli 2009 Bambinuto photo
HK$255.00
Greco di Tufo Picoli 2010 Bambinuto photo
HK$255.00
Greco di Tufo Picoli 2010 Magnum Bambinuto photo
HK$520.00
Greco di Tufo Picoli 2011 Magnum Bambinuto photo
HK$460.00
Greco di Tufo Picoli 2012 Bambinuto photo
HK$225.00
Greco di Tufo Picoli 2015 Bambinuto photo
HK$210.00
Greco di Tufo Picoli 2015 Magnum Bambinuto photo
HK$430.00