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 ('2163', '1784', '2012') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

CALATHUS PINOT NOIR 2007

Blend: Pinot Noir 100%
Sight: Intense red with garnet tones
Nose: Spicy, with predominance of blackcurrant and ripe fruits. Also vanilla and mocha coffee
Mouth: A sweet entrance. Its tannins are pleasant and long lasting.

TERRAZAS RESERVA MALBEC 2007

Blend: Malbec 100%
Sight: Deep violet, with ruby highlights.
Nose: Intense notes of black cherries, figs and sour cherry jam, followed by a delicate violet perfume. Spicy notes, like white pepper, and liquorices.Barrel ageing contributes with a caramel and vanilla touches.
Mouth: Stands by its intensity and balance. With firm and well rounded tannins, offers a long mouth finish. Results in an extremely elegant wine.

LOS AILOS SYRAH MALBEC 2008

Blend: Malbec 60% - Syrah 40%
Sight: Deep red violet with bright red tinges. Very appealing to sight, which is characteristic of young wines
Nose: Very complex wine in aroma provided by the two varieties that make up the wine. Spicy aroma can be appreciated in balance with red fruits as gooseberries, raspberries, red berries, trufles, cherries and plumbs. Also outstanding aroma of vanilla, chocolate and coffee provided by six-month aging in French oak barrels. The harmony of all these features makes this wine fresh and elegant.
Mouth: Smoothness and elegance are due to its balanced and sweet tanins. Intense in its structure with pleasant end in mouth. The right combination between oak and wine is manifested in the soft, clean retro taste with a good expression of primary aromas.