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 ('2102', '2676', '2687') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

LAS MORAS BLACK LABEL CABERNET - CABERNET 2008

Blend: Cabernet Franc 50% - Cabernet Sauvignon 50%
Sight: Deep Red
Nose: Green pepper, spices, blackberries
Mouth: Dark fruit character, dark chocolate and well integrated oak. Fine tannins and silky texture

OTERO RAMOS BLEND 2007

Blend:
Sight: Ruby red color, with intense purple shades.
Nose: Great complexity in the nose due to its perfect and well balanced combination of varieties, which grant a wide range of aromas.
Mouth: Ripe red fruit, spices, black and red pepper. Soft and sweet start in the mouth, of balanced, pleasant and round tannins. Complex finish due to the unique combination of varietals.

GRITOS CLÁSICO VARIETAL CHARDONNAY 2012

Blend: Chardonnay 100%
Sight: Intense greenish yellow color.
Nose: Aromas of flowers and fruits, such as ripe yellow peaches, banana and pineapple.
Mouth: In the mouth, the sensations in the nose are remembered. Well defined taste, full-bodied, long finish. Great balance.