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 ('2252', '2350', '2472') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

PIATTELLI TRINITA 2009

Blend: Malbec 60% - Cabernet Sauvignon 25% - Merlot 15%
Sight: intense maroon-red color with violet tints
Nose: it offers aromas of fruits such as raspberry, cherry and plum, characteristic of the varietals that make up this blend. Besides, black pepper and clove are also present on the nose, as well as chocolate and vanilla notes, contributed by its oak aging
Mouth: on the palate, it is perceived as a balanced, full-bodied and persistent wine

BENMARCO MALBEC 2008

Blend: Malbec 90% - Bonarda 10%
Sight: it has an intense purple color
Nose: intense aromas of ripe red fruits and roasted coffee beans
Mouth: it is lush, full-bodied and penetrating on the palate with cassis and currant jam flavors, balanced acidity and strong tannins. Bonarda grants this typical Argentina’s Malbec a greater complexity and a better balance

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