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 ('1893', '2444', '2681') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

PIATTELLI GRAN RESERVA MALBEC 2007

Blend: Malbec 100%
Sight: Deep burgundy color
Nose: In the nose, it displays floral aromas as well as black fruits, characteristic of this varietal, combined with vanilla and chocolate notes granted by its oak aging.
Mouth: In the mouth, sweet tannins, characteristic of Malbec, emerge within its great structure granting an unctuous and lingering finish.

TRIVENTO AMADO SUR TORRONTÉS 2010

Blend: Torrontés 75% - Viognier 15% - Chardonnay 10%
Sight: Delicate yellow with refined green tinges
Nose: Roses and jasmine with a touch of citric fruits, white peach and apricot. Some orange peel notes
Mouth: Exquisite fresh and mineral acidity. A long, silky and fruity finish

DOÑA SILVINA MALBEC

Blend: Malbec 100%
Sight: Deep plum color with violet tones. Clean and intense.
Nose: Aromas of red ripe fruit combined with elegant notes from the French oak, such as smoke, chocolate, cocoa and vanilla.
Mouth: Straight wine, easy to drink, with balanced acidity and alcohol. Its body and notable texture fade delicately to a medium end.