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 ('1850', '1808', '2559') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

SEPTIMA MALBEC 2007

Blend: Malbec 100%
Sight: Deep red with purple hues.
Nose: Fresh berries balanced with the oak of aging, plus vanilla and roasted scents with touches of strawberry and cherry jams. Slightly reminiscent of rosemary, watermelon, pear and raspberry.
Mouth: Smooth and elegant flavour of very sweet tannins reminding raspberry jam. A fruity aftertaste mixed with touches ok smoked oak. Very balanced and persistent in the mouth.

DON BALTAZAR MALBEC 2008

Blend: Malbec 100%
Sight: It displays a very intense purplish red color granted by its ripeness.
Nose: Complex nose that combines red fruit aromas, such as plum and morello cherry, with pleasant spiced notes. Its aging in French and American oak grants it a touch of vanilla and caramel.
Mouth: Elegant wine with sweet and well balanced tannins as well as a long finish.

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