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 ('2119', '2584', '2732') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

LAS PERDICES RESERVA BONARDA 2008

Blend: Bonarda 100%
Sight: Intense purplish red color
Nose: Complex red fruit aromas with strong oak hints.
Mouth: Smooth and balanced in the mouth with plum and morello cherry notes.

VICTORIO ALTIERI GRAN RESERVA 2010

Blend: Malbec 85% - Malbec 85% - Tannat 5% - Tannat 5% - Cabernet Sauvignon 10% - Cabernet Sauvignon 10%
Sight: intense purplish red
Mouth: great concentration and structure, firm tannins, spices and fruit mingle witha pleasant French oak taste

PROEMIO GRAN RESERVE

Blend: Malbec 50% - Merlot 30% - Cabernet Sauvignon 10% - Syrah 10%
Sight: Complex combination of dark colors with strong tears in the glass.
Nose: It offers perfumed aromas of fresh crushed dark fruit and red fruit flavors, with intense spicy notes and a touch of mocha and espresso. Mineral and chocolate notes linger on the unctuous finish.
Mouth: This expressive red shows plenty of oak, with cocoa and coffee flavors, but the ripe, bright core of plum, blueberry and cassis keeps it all balanced, with rich, well-integrated tannins matched with fresh acidity.This red wine exhibits plenty of fresh blackberry and black cherry notes, but also iron, mineral and loam flavors that give complexity and a sense of place. Well-balanced and long on the aftertaste. Cabernet Sauvignon, Merlot, Syrah and mainly Malbec are a good combination.