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 ('381', '2086', '2608') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

FINCA 8 RESERVA MALBEC 2008

Blend: Malbec 100%
Sight: Deep red purplish color with strong legs.
Nose: In the nose, it displays red and black fruits aromas, typical of the varietal, and floral aromas such as violets and roses, together with vanilla, tobacco, coffee and toast notes granted by its aging in French oak.
Mouth: In the mouth, it is a complex and well-balanced wine with plum and black cherry flavors as well as sweet tannins.

ALEGORÍA GRAN RESERVA CABERNET SAUVIGNON 2007

Blend: Cabernet Sauvignon 100%
Sight: Dark red color with ruby hues.
Nose: Plums, blackcurrant, tobacco and light peper notes.
Mouth: Dishes rich in proteins and with high fat content. Red meats such as lamb or other preparations with variety of ingredients. Hard cheeses.

PORTILLO MALBEC 2011

Blend: Malbec 100%
Sight: Ruby-red wine with very intense purplish tints.
Nose: Displaying a fresh and fruity nose, enhanced by hints of plums, black berries and a touch of vanilla.
Mouth: Fresh fruit flavors, supported by sweet and round tannins, and good structure contributed by oak. Long and fruity finish.