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 ('1937', '2402', '2663') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

PASCUAL TOSO CABERNET SAUVIGNON 2008

Blend: Cabernet Sauvignon 100%
Sight: Deep ruby red color with purplish hues
Nose: Fruity aromas combined with notes of pepper, vainilla and chocolate.
Mouth: Firm and sweet tannins.

FINCA FLICHMAN ROSÉ 2011

Blend: Malbec 50% - Shiraz 50%
Sight: Deep pink color
Nose: Fresh strawberries and cherries
Mouth: Plain of fruits. Very good balance acidity/sugar

SIE7E PASOS CABERNET SAUVIGNON

Blend: Cabernet Sauvignon 100%
Sight: Attractive deep purple color with terra-cotta tinges
Nose: On the nose it is elegant, full of concentrated fruit aromas where raspberries, currants and blackberries stand out. Gentle hints of vanilla and chocolate derived from its oak aging can be percieved
Mouth: The palate showsa round body and a long finish that ends with ripe tannins and flavors of black fruits