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 ('379', '1834', '2559') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

FINCA 8 MALBEC 2009

Blend: Malbec 100%
Sight: Red color with purplish hues
Nose: In the nose, it displays ripe fruit aromas such as plum, cherry and fresh floral notes such as violets. There are also aromas of red fruit jam combined with spiced notes.
Mouth: In the mouth, red and black fruit flavors stand out. This is a gentle, fresh and round wine with great volume and acidity as well as a lingering finish.

GRAFFIGNA CENTENARIO MALBEC 2007

Blend: Malbec 100%
Sight: Deep red with traces of violet
Nose: Of great complexity with very ripe dark berries and a touch of black pepper and spiced fragances
Mouth: Well integrated delicate ripe tannins and complex finish with hints of coffee, vanilla and toast

ACONCAGUA VARIETALES - TORRONTÉS 2011

Blend: Torrontés 100%
Sight: Straw-color wine
Nose: Intensely floral and citrus aromas and flavors
Mouth: Rich and creamy texture in the mouth