SELECT `ws_vino`.*, `a1`.`value` as cata_vista, `a2`.`value` as cata_nariz, `a3`.`value` as cata_gusto
FROM (`ws_vino`)
LEFT JOIN `wp_icl_strings` as a1 ON `ws_vino`.`cata_vista` = `a1`.`name`
LEFT JOIN `wp_icl_string_translations` as b1 ON `a1`.`id` = `b1`.`string_id`
LEFT JOIN `wp_icl_strings` as a2 ON `ws_vino`.`cata_nariz` = `a2`.`name`
LEFT JOIN `wp_icl_string_translations` as b2 ON `a2`.`id` = `b2`.`string_id`
LEFT JOIN `wp_icl_strings` as a3 ON `ws_vino`.`cata_gusto` = `a3`.`name`
LEFT JOIN `wp_icl_string_translations` as b3 ON `a3`.`id` = `b3`.`string_id`
WHERE `visible_guia` = '1'
AND `visible` = '1'
AND `ws_vino`.`vino_id` IN ('2268', '2379', '2637') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

KINIÉN DE DON RAÚL 2007

Blend: Malbec 60% - Cabernet Sauvignon 30% - Petit Verdot 10%
Sight: very intense and deep red color with violet hues
Nose: powerful nose with intense notes of red and black fruits. Blackberries and plums jam is intermingled with a touch of sweet spices. Besides, toasty, vanilla and caramel aromas are also perceived.
Mouth: it is concentrated in flavors and aromas. Velvety and sweet start in the mouth, it offers fruity and spicy aromas. Its sweet and round tannins are combined with an excellent acidity. It is a well-balanced, powerful and elegant wine.

DOMAINE JEAN BOUSQUET RESERVE MALBEC 2010

Blend: Malbec 100%
Sight: Dark purple, almost black typical of the best Malbec from Argentina
Nose: Rich and intense aromas of blackberry with notes of pepper black and grosella
Mouth: Balanced and elegant, with expression of pure fruit. Flavors of raspberry, blackberry and fig with chocolate notes, graphite and mineral. Good acidity with a smooth mouth feel, an excellent structure and a long finish

MALMA CUVEE RESERVE EXTRA BRUT

Blend: Pinot Noir 70%
Sight: Deep yellow color with golden hues.
Nose: Brimming with aromas of red berries, exotic citrus and hints of toasted brioche and huzelnuts.
Mouth: Fresh and bright with a delicate, creamy finish.