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 ('2260', '2732', '2740') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

LARIVIERE YTURBE PARTIDA LIMITADA MALBEC 2008

Blend: Malbec 100%
Sight: it exhibits an intense and bright ruby-red color with purplish hues
Nose: the fruit expression prevails over oak aromas
Mouth: the storage makes fruit flavors be more velvety, elegant and lustful

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.

VIÑAS DE ALTO SALVADOR TEMPRANILLO ORGANICO 2011

Blend: Tempranillo 100%
Sight: Bright red, clean and bright with black flashes.
Nose: Notes of black fruit, with aromas of spice, fig and plum jam, highly complex.
Mouth: Good entry, harmonious, unctous, firm but sweet tannins. Long finish.