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 ('2188', '2241', '2764') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

LAS PERDICES MALBEC 2008

Blend: Malbec 100%
Sight: Intense purple red color
Nose: Complex red fruit aromas with delicate oak touches.
Mouth: In the mouth, it is smooth and balanced wine with plum and morello cherry notes.

CALLIA ALTA SHIRAZ MALBEC 2010

Blend: Shiraz 70% - Malbec 30%
Sight: it is a deep purplish-red colored and vivacious wine, showing the typicity of the Malbec
Nose: it offers aromas of ripe figs, cinnamon and liquorice, revealing the presence of the shiraz in this blend. Red fruit aromas, such as plums and cherries, typical of the Malbec, are also perceived
Mouth: with a great freshness and marked balance, this wine is complex, well-structured and silky, with sweet, ripe and harmonious tannins

MAULA & MISERY MOUSE SAUVIGNON BLANC 2010

Blend: Sauvignon Blanc 100%
Sight: Limpid and shiny, with pale colors and greenish sparks.
Nose: It is aromatic and elegant. Impresses with its citric notes and its charming pear and peach notes.
Mouth: Smooth and fresh, predominating citric tones with a long and persistant finish in the mouth.