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 ('2519', '2589', '2670') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

AMALAYA GRAN CORTE 2010

Blend: Malbec 85% - Bonarda 8% - Cabernet Franc 7%
Sight: Intense and lively, deep red color almost black with purple edges.
Nose: Three layers of aromas. The Cabernet Franc contributes eucalyptus notes. Chocolate and vanilla from the oak barrels. Fruity aromas of plum jam and wild blackberries.
Mouth: Velvety and robust. The structure is made up of fruity and intense tannins with a middle mouth full of fruit explosion that comes from Malbec. At the end some confitures, chocolate, and liquorish notes appear.

SINFIN SAUVIGNON BLANC 2010

Blend: Sauvignon Blanc 100%
Sight: This wine displays a greenish yellow color with golden hues.
Nose: Notes of pink grapefruit, mango and asparagus.
Mouth: Fresh fruit and a stressed acidity remain in the palate. Its carbonic concentration enhances its varietal expression and turns it into an elegant easy-to-drink wine.

SOPHENIA SYNTHESIS THE BLEND 2009

Blend:
Sight: Deep and intense ruby red color with violet dyes
Nose: It shows a great aromatic intensity of ripe red and black fruits, blended with spicy and mineral notes like black pepper and eucalyptus. Its long ageing in Frenck oak shines elegant smoke aromas of vanilla, tobacco and chocolate.
Mouth: Sweet and generous in the entry, of complete and concentrated palate. It shows mature and voluminous tannins. Its mineral and fruity sensations venture a wine of great longevity, elegance and finesse. We recommend decanting 20 minutes before the service