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 ('2051', '2268', '2282') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

ANDELUNA GRAND RESERVE CABERNET FRANC 2006

Blend: Cabernet Franc 100%
Sight: Intense red color, with violet highlights.
Nose: A combination of aromas reminiscent of anise, ripe red fruits and spices, with touches of chocolate and tobacco acquired during the time spent in French oak barrels.
Mouth: A structured, full bodied wine, with rounded tannins giving a long finish.

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.

GIMENEZ RIILI GRAN RESERVA 2007

Blend: Malbec 100%
Sight: it exhibits an intense red color with violet hues
Nose: it flaunts aromas of red and black berries, with vanilla, toast and coffee notes
Mouth: on the palate, it has a great complexity. This wine is ripe and full-bodied with well-balanced tannins