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 ('1906', '1894', '2596') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

PIATTELLI GRAND RESERVE TRINITA 2007

Blend: Malbec 60% - Cabernet Sauvignon 25% - Merlot 15%
Sight: Intense burgundy color with purplish nuances
Nose: In the nose, it displays fruit aromas such as raspberry, cherry and plum, characteristic of the varietals that make up this blend. There are also some spiced aromas such as black pepper and clove as well as chocolate and vanilla hints granted by its oak aging.
Mouth: This is a balanced full-bodied wine with a lingering finish.

FINCA EL ORIGEN RESERVA TORRONTÉS 2009

Blend: Torrontés 100%
Sight: Pale yellow color with greenish hues.
Nose: Its complex aromatic expression makes it an intense and attractive wine. In the nose, there is a balance between floral and fruity aromas, standing out rose petals, lavender, orange peel and pineapple.
Mouth: In the mouth, it shows a sweet entry with balanced acidity that grants it great freshness.

CENTENARIO MALBEC 2010

Blend: Malbec 100%