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 ('2142', '2095', '2723') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

FINCA PEDERNAL MALBEC 2007

Blend: Malbec 100%
Sight: Deep purple red
Nose: Red fruit, cassis and eucaliptus aromas
Mouth: Nice texture, wide, fleshy, with balanced sweet tannins

PASCUAL TOSO MALBEC 2013

Blend: Malbec 100%
Sight: Intense red color
Nose: Plums and quince with a slight hint of oak
Mouth: Sweet and mild tannins with slight vanilla and smoky notes

SAURUS SELECT PINOT NOIR 2010

Blend: Pinot Noir 100%
Sight: The sight features bright red tones.
Nose: This Pinot Noir has plenty floral aromas, like roses and violets, combined with red fruit scents such as red currants, raspberries and strawberries. Mushrooms and mineral aromas stand out together with some vanilla and cocoa notes, due to ageing in oak barrels.
Mouth: Medium-bodied red, of ultrafine tannins and fruity nuances that wave through a finish of superior depth and dimension.