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 ('2309', '2358', '2458') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

ALTIVO BARREL SELECTION MALBEC 2008

Blend: Malbec 100%
Sight: bright, medium ruby-red
Nose: subdued aromas of dark fruits, chocolate and licorice
Mouth: silky-smooth and broad on the palate, with an absence of edges to the dark raspberry and spice flavors. Finishes with rather suave tannins and good length and lift.

DANTE ROBINO BONARDA 2009

Blend: Bonarda 100%
Sight: it exhibits an intense purplish-red color
Nose: its nose displays a fruity expression typical of this grape variety, where cherry and rapberry aromas stand out, perfectly combined with vanilla and chocolate notes granted by oak
Mouth: it is perceived as a harmonious wine offering a pleasant finish

TRIVENTO TRIBU MERLOT 2010

Blend: Merlot 100%
Sight: Ruby red with blue tinges
Nose: Combination of sweet peas, fresh berries and marmalade
Mouth: Well-balanced with pleasant tannins and persistent finish