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 ('2133', '2113', '2595') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

EFIGENIA EXTRA BRUT 2008

Blend: Pinot Noir 70% - Chardonnay 30%
Sight: The elegant and delicate presence of Pinot Noir grants it bright gold shades.
Nose: It displays aromas of yeasts and almonds combined with slight toasted notes.
Mouth: In the mouth, it is a smooth and full bodied wine with good acidity. It has a long aftertaste as well as fine and intense bubbles.

AMPAKAMA INTENSO CHARDONNAY 2010

Blend: Chardonnay 100%
Sight: Light yellow color with attractive greenish sparkles.
Nose: Delicate combination of intense tropical aromas such as banana, pineapple and apple. It is also combined with light notes of vanilla and toast provided by its aging in oak barrels.
Mouth:

CENTENARIO PINOT GRIGIO 2011

Blend: Pinot Grigio 100%
Sight: Light yellow with delicate silver hues.
Nose: Subtle floral aromas with notes of jasmine and hints of white fruits such as peaches and apricots.
Mouth: Fresh, young, with delicate, yet spurprising, fruit flavors and a refined finish.