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 ('2113', '2636', '2666') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

EFIGENIA EXTRA BRUT 2008

Blend: Pinot Noir 70% - Chardonnay 30%
Sight: The elegant and delicate presence of Pinot Noir grants it bright gold shades.
Nose: It displays aromas of yeasts and almonds combined with slight toasted notes.
Mouth: In the mouth, it is a smooth and full bodied wine with good acidity. It has a long aftertaste as well as fine and intense bubbles.

AMPAKAMA INTENSO CABERNET MALBEC 2010

Blend: Malbec 100%
Sight: To the eye this wine presents an intense violet red color.
Nose: In the nose it is complex where fragances of red fruits like morello cherries, plums and strawberries are mixed. It displays notes of vanilla and caramel, contributed by its aging in oak barrels.
Mouth: It is an agreeable wine, with good structure and a long finish.

ALTOSUR MALBEC 2012

Blend: Malbec 100%
Sight: Attractive red color with purple hues
Nose: Aromas of intense ripe fruit: cherries, blackberries, blueberries, and fresh plums, combined with spicy and floral hints
Mouth: Sweet and round tannins that increase its fruit sensation and balance. Wine of good intensity, concentration and long after taste