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 ('1866', '2289', '2663') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

ATIPAX RESERVA BLEND 2004

Blend: Malbec 50% - Cabernet Sauvignon 25% - Bonarda 25%
Sight: Intense red with black tones.
Nose: Aroma of mature red fruits, mermalade, cassis and chocolate.
Mouth: Soft and persistant, with great structure and mature and round tannins.

URRACA CHARDONNAY 2013

Blend: Chardonnay 100%
Sight: it exhibits a bright golden yellow color with greenish hues
Nose: on the nose, it is a fresh wine with an intense presence of fruit aromas
Mouth: in the mouth, it is a pleasant varietal with balanced acidity

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