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 ('144', '1893', '2675') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

CATALPA MERLOT 2007

Blend: Merlot 100%

PIATTELLI GRAN RESERVA MALBEC 2007

Blend: Malbec 100%
Sight: Deep burgundy color
Nose: In the nose, it displays floral aromas as well as black fruits, characteristic of this varietal, combined with vanilla and chocolate notes granted by its oak aging.
Mouth: In the mouth, sweet tannins, characteristic of Malbec, emerge within its great structure granting an unctuous and lingering finish.

COLONIA LAS LIEBRES BONARDA 2011

Blend: Bonarda 100%
Sight: A deep and brilliant red-purple color.
Nose: A penetrating nose of roses, ripe red fruit and spicy black pepper.
Mouth: On the palate the wine is lean, elegant and subtle, hinting at its unoaked, low intervention winemaking style in order to preserve the characteristics of the Bonarda Argentina grape. Finishes with soft, sweet tannins, freshness and lively natural acidity.