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 ('1823', '2263', '2623') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

MARGOT BLANC DE BLANCS

Blend: Chardonnay 80% - Chenin 20%
Sight: Golden, with medium intensity greenish sparkles, shiny, with little pearly bubbles producing great movement. Thin and persistent bubble size.
Nose: Intense aromas of tropical fruits, vanilla and honey with green apple and citric touches on a yeast bottom, which intensely release when its bubbles move.
Mouth: Wide, intense, well structured and unctuous entry with lots of fruits and honey resulting in a fresh and citric finish that invites to continue drinking.

BLEND DE SELECCIÓN 2 MALBEC 2005

Blend: Malbec 100%
Sight: it shows an intense bluish-red color
Nose: it is a blend of the Malbec variety from 2 different vineyards. One of them, located in Tupungato, grants it aromas of ripe figs, dried fruits and a hint of mint. The other one, younger and situated in Tunuyán, gives the wine distinctive notes of plums and blackberry with delicate perfume of violets
Mouth: this blend of perfect structure and concentration is unctuous, round and elegant with balanced tannins. It offers a long finish

BUDEGUER 4000 MALBEC 2009

Blend: Malbec 100%
Sight: Deep ruby purple color, ripe black frut aromas from cherries, plums and blackberrys.
Nose: Subtle floral notes of violets and roses translate into a balanced wine with hints of vainilla and coffee provided by their well-integrated oak.
Mouth: Freshness and aromatic persistence.