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 ('2412', '2714', '2744') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

DOÑA PAULA ESTATE CHARDONNAY 2010

Blend: Chardonnay 100%
Sight: Eye-catching golden yellow color.
Nose: It has a mineral character combined with tropical fruits, pear and citrus notes.
Mouth: Complex and fresh.

CALIGIORE ORGANIC LEGACY 2009

Blend: Malbec 100%
Sight: Deep purple color with black tinges.
Nose: On the nose, many aromatic layers comes up as it remains in the glass, inviting to discover its complex bouquet. Black fruits and ripe plums backed by delicate tosted bread, coconut and chocolate notes.
Mouth: Textured and deep mouthfeel with velvety tannins and balanced acidity.

GERNOT LANGES 2006

Blend: Malbec 70% - Cabernet Sauvignon 20% - Cabernet Franc 10%
Sight: Deep and dark.
Nose: Intense toast, mocha and black fruit aromas.
Mouth: The palate is full and thick, with soft tanins. Very complex and rich, with black ripe fruit and spicy flavors. Persistent and long finish.