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 ('2096', '2322', '2406') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

LAS MORAS BLACK LABEL SAUVIGNON BLANC 2009

Blend: Sauvignon Blanc 100%
Sight: Golden
Nose: This wine combines tropical Fruit intensity and has a herbal basis.
Mouth: The wine is fruity, lively and crisp and has a pleasant balance of acidity. Medium body, good concentration and long lingering aftertaste

CALLE FUNES 2007

Blend: Malbec 100%
Sight: it exhibits an intense ruby-red color with violet hues
Nose: it offers raspberry aromas
Mouth: its sweet tannins stand out, as well as toasty and vanilla notes given by French and American oak barrel aging

FINCA EL ORIGEN MALBEC 2010

Blend: Malbec 100%
Sight: This Malbec has an intense and deep purple color.
Nose: In the nose, it displays aromas of red fruits such as red plum and morello cherry, combined with floral notes such as violets .
Mouth: In the mouth, it is a velvety and silky wine with medium structure as well as mild, sweet and ripe tannins.