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 ('2164', '1987', '2579') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

SOLAR DE ORFILA MALBEC 2008

Blend: Malbec 100%
Sight: Intense violet red with blackish shades
Nose: Complex aromas of ripe red fruit reminiscent of plums and cherries
Mouth: Velvety texture, but intense and ripe tannins, with a hint of vanilla and chocolate, characteristic of oak toasting.

LOS AILOS CHARDONNAY 2008

Blend: Chardonnay 100%
Sight: Intense lemon yellow color
Nose: Banana, pineapple, peach and citrus in a subtle combination give the feeling of a fruit cocktail.
Mouth: Fruit like character, fresh and sweet very soft to the palate. The right level of acidity highlights the aroma and persistence in mouth.

FINCA EL ORIGEN GRAN RESERVA MALBEC 2010

Blend: Malbec 95% - Cabernet Sauvignon 3% - Bonarda 2%
Sight: Exceptional purple color.
Nose: In the nose, the aromas are dominated by red plums, morello cherries, figs, dried apricots and a delicate perfume of violets. All this is harmonized with its oak ageing, which grants it elegant notes of vanilla, chocolate, toast and caramel.
Mouth: This is a full-bodied wine of great structure and concentration. Its excellent balance between acidity and rounded ripe tannins results in a wine with personality. It has a pleasant and lingering finish.