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 ('2311', '2472', '2658') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

LA CELIA ELITE MALBEC-TANNAT 2008

Blend: Malbec 60% - Tannat 40%
Sight: it exhibits a deep and bright red color
Nose: aromas of red fruit jams and spices like black pepper stand out, combined with notes imparted by its oak aging
Mouth: its ripe tannins provide it strength and structure. It is a wine of great personality, easy to drink

HUBERT WEBER CELLAR SELECTION CABERNET SAUVIGNON 2007

Blend: Cabernet Sauvignon 100%
Sight: Deep dark red, "Baccarat" rose red
Nose: Hyacinths, sweet paprika, cassis, black bitter chocholate, snuff pipe bag out of leather, menthol, larch resin, roses, incense, cinnamon, bitter orange peel
Mouth: Soft entry that evovles into fruity-spicy, with beautiful and tasty Cabernet Sauvignon tannins type without being too astringent, with some black chocolate flavor, medium body and characteristic sweet wine made ​​from ripe Cabernet-Sauvignon grapes. Good presence, of a wine aged in oak barrels for 2 years

FINCA 8 MALBEC 2010

Blend: Malbec 100%
Sight: Red color with purplish hues
Nose: In the nose, it displays ripe fruit aromas such as plum, cherry and fresh floral notes such as violets. There are also aromas of red fruit jam combined with spiced notes.
Mouth: In the mouth, red and black fruit flavors stand out. This is a gentle, fresh and round wine with great volume and acidity as well as a lingering finish.