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 ('2250', '2261', '2520') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

PIATTELLI GRAND RESERVE MALBEC 2009

Blend: Malbec 100%
Sight: it exhibits a deep maroon-red color
Nose: aromas of black fruits stand out. Vanilla and chocolate notes, granted by oak aging, are also perceived combined with floral aromas
Mouth: on the palate, sweet tannins, typical of the Malbec, emerge within its great structure, offering an unctuous and long finish

JOFFRÉ E HIJAS GRAN BONARDA 2007

Blend: Bonarda 100%
Sight: it is an elegant wine of intense purplish-red color with blue hues
Nose: on the nose, expressive notes of red fruits stand out, as well as hints of blackberry, raspberry and tomato leaves. Besides, a jam aroma with mint is also perceived combined with chocolate and a delicate tobacco scent
Mouth: in the mouth, it is a round, robust, unctuous wine with great structure and a memorable long aftertaste

CARLA CHIARO RESERVA MALBEC 2009

Blend: Malbec 100%
Sight: Intense color, purplish red to black shades.
Nose: Good balance between red fruits and chocolate and coffee notes.
Mouth: The mildness of its tannins makes it special, long and with a slight liquor taste, but with a strong character.