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 ('1848', '2128', '2613') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

ALZAMORA SYRAH 2009

Blend: Syrah 100%
Sight: Intense purplish red color with blue tinges
Nose: It has a great personality granted by its spiced aromas, a delicate touch of clove and a soft bouquet of red fruits, such as cherries blackberries and raspberries. It displays notes of vanilla and caramel, granted by its aging in new French oak casks during 12 months.
Mouth: Unctuous wine with a long finish

NOVUS ORDO MALBEC 2008

Blend: Malbec 100%
Sight: Ruby red color with purplish hues
Nose: Fresh wine with aromas of forest fruit, vibrant cherry and mild plum.
Mouth: Wide, vibrant and fresh entry in mouth with sweet tannins, very good acidity and lingering finish.