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 ('2112', '2376', '2427') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

YLLUM RESERVE CABERNET SAUVIGNON 2006

Blend: Cabernet Sauvignon 100%
Sight: Intense and bright bordeaux red color with dark shades
Nose: Plenty of ripe red and black fruit, black pepper and notes of chocolate and coffee.
Mouth: In the mouth, it is elegant and powerful with a long aftertaste and ripe tannins.

CABALLERO DE LA CEPA MERLOT 2010

Blend: Merlot 100%
Sight: Ruby red color
Nose: Blackberries from the forest and some balsamic aromas
Mouth: A concentration of berry fruits and vanilla

TRIVENTO EOLO MALBEC 2008

Blend: Malbec 93% - Cabernet Sauvignon 5% - Petit Verdot 2%
Sight: Dark garnet red envelops captivating purplish reflections.
Nose: An accomplished embrace of the fruit nested within the Malbec clusters, evoking berries, black figs and cherries. Contributions of the Luján de Cuyo terroir are not overshadowed, coming through with reminiscences of lime blossom and clove. The oak provides a stroke of tobacco, while a touch of Petit Verdot gives off notes of graphite.
Mouth: Sweet, juicy and energetic tannins delight on the centre of the palate with pleasant sensations of unctuosity. Complete, with a long and sugary finish in which the Cabernet Sauvignon is discovered within the harmonious structure’s design.