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 ('2518', '2604', '2625') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

AMALAYA BLANCO 2011

Blend: Torrontés 85% - Riesling 15%
Sight: Bright yellow with greenish edges.
Nose: Subtle and complex fruity aromas where apple and floral notes outstand.
Mouth: Sweet entry full of weight. Mineral notes and a touch of honey distinguish. The end is fresh with a kind acidity.

GRAN DANTE MALBEC 2007

Blend: Malbec 100%
Sight: Deep red with slight purplish hues.
Nose: Elegant and smoked. Red fruit aromas mixed with dense chocolate and vanilla notes.
Mouth: Intense and unctuous with smooth and sweet tannins. Long lasting finish.

BUDEGUER PATRIMONIO MALBEC 2009

Blend: Malbec 100%
Sight: Bright red with purplish notes.
Nose: The balance achieved between the wine and the oak allows us to appreciate fruity aromas such us, black cherry, ripe plum, blackberry and floral notes, typical of Malbec from Valle de Uco, and mixed with mild tobacco, chocolate notes and vainilla aromas provided by the oak.
Mouth: Elegant with sweet and round tannins. Good acidity, a common characteristic from the region that gives longevity to the wine.