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 ('2231', '2507', '2537') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

PRIMUS MALBEC 2006

Blend: Malbec 100%
Sight: bright and intense color with blackish and purplish hues
Nose: it displays complex and intense aromas of red and black berries with a spiced hint of clove and pepper
Mouth: in the mouth, it offers firm tannins giving it great structure for a long storage. The acidity is balanced with the sweetness of alcohol. It is fresh with long finish

KOOCH MALBEC 2008

Blend: Malbec 100%
Sight: Intense, dark, red color
Nose: The nose is very intense with complex notes of candied fruit from the Malbec and the oak aging.
Mouth: The mouth is ample, voluminous and inviting. The finish is long and persistent.

MENDEL SEMILLON 2011

Blend: Semillón 100%
Sight: Very nice ambar color, with some green hints.
Nose: Fresh, elegant and intense. It remarkable at the first snif fresh herbes and citrics notes, later we can find some typical descriptors as white flowers and honey. Some oak notes such as coconut and soft vanilla aromas.
Mouth: The wine has a very fresh mouth filling with a well balanced acidity that remarks the freshness of the wine. The aromatic in the back of the mouth are similar to those in the nose. It is a very dense wine, elegant, soft and velvety with a persistent end.