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 ('2054', '2529', '2721') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

ANDELUNA GRAND RESERVE PASIONADO BLEND 2005

Blend: Malbec 50% - Merlot 20% - Cabernet Sauvignon 20% - Cabernet Franc 10%
Sight: Intense red color, with violet and ruby highlights
Nose: Complex aromas of ripe red fruits, typical of Malbec, the spiciness of Cabernet Sauvignon and Merlot, plus delicate hints of anise released by the Cabernet Franc. The aromatic richness of this Blend gets completion with the touch of vanilla and chocolate acquired from new French oak barrels, where it rested for 18 months.
Mouth: This is a full bodied, structured wine with well rounded tannins that add a long finish.

LEGEND OF POLO 2010

Blend: Malbec 100%
Sight: Deep red with violet hues and crimson glints.
Nose: Fresh red fruits like berries, strawberries and cherries combined with clove and smoke. Vanilla and toasts aromas from the oak.
Mouth: Presence and strong personality. Soft and exquisite tannins. Impetuous and pleasant ending.

FAMILIA SCHROEDER PINOT NOIR-MALBEC 2007

Blend: Pinot Noir 54% - Malbec 46%
Sight: Red wine of deep bright red color with some violet hints.
Nose: This blend features a complex nose. Ripe red fruits aromas such as plums, sour berries and cassis, gently combined with floral and spicy nuances. Delicate vanilla and chocolate tones were developed during the long ageing in french oak barrels.
Mouth: Sophisticated mouth-feel and remarkable elegance. The wine expands on the palate letting the flavors linger persistently.