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 ('2071', '2476', '2633') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

SIETEFINCAS BLEND MALBEC SECRETO 2007

Blend: Malbec 60% - Cabernet Sauvignon 15% - Cabernet Franc 15% - Petit Verdot 10%
Sight: very intense purplish red color
Nose: notes of chocolate, ripe black plums and flowers
Mouth: sweet and strong tannins; lingering finish

MAIRENA BONARDA RESERVE 2008

Blend: Bonarda 100%
Sight: Vigorous with a lively, intense and bright red colour with purple hues.
Nose: Luscious ripe red fruit, cherries and plums aromas, which gives this varietal its true identity. Its delicate herbaceous notes blend well with blackberries aromas. It displays hints of coffee laced with vanilla notes originated during its aging in french oak barrels for 12 months.
Mouth: Fleshy, thick and full-bodied. It is captivating for its rich acidity and velvet tannins.

OJO DE AGUA MALBEC 2010

Blend: Malbec 100%
Sight: Very dark red, soft and lush.
Nose: Intense red fruit.
Mouth: Pleasant sweetness that is balanced with good acidity.