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 ('2207', '1985', '2245') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

ORFILA MALBEC 2008

Blend: Malbec 100%
Sight: Vivid ruby red
Nose: Expressive and complex, with precursors of berries aromas, ripe.
Mouth: Round and pleasant in the mouth, with sweet tannins and pleasant final taste

SIETEFINCAS EXTRA BRUT 2010

Blend: Chardonnay 60% - Chenin 40%
Sight: greenish yellow color
Nose: very fruity wine with notes of pineapple and white peah, fresh and young
Mouth: very good acidity, with characteristic fruits notes granted by its grape varieties

GRAND CALLIA 2006

Blend: Shiraz 40% - Tannat 20% - Merlot 20% - Malbec 20%
Sight: it exhibits an intense and deep red color, with purplish and blackish tints
Nose: it displays spicy and well- balanced aromas, with a touch of liquorice, vanilla and coconut
Mouth: on the palate, it is unctuous, with gentle round tannins and a strong presence of spices granted by oak aging. It is a wine with a good structure for storage