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 ('2517', '2524', '2719') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

AMALAYA TINTO 2010

Blend: Malbec 75% - Tannat 5% - Shiraz 5% - Cabernet Sauvignon 15%
Sight: Deep ruby red and bright with purple tones.
Nose: Very fruity and sweet with intense aromas of red berries like cherry and raspberry, and black berries such as mulberry. A soft chocolate touch due to its oaking.
Mouth: Fresh with high fruit expression and spicy notes such as pepper. It is very intense, well structured with a long mouthfil. Very easy to drink due to its soft, gentle, and round tannins.

BENMARCO EXPRESIVO 2009

Blend: Malbec 50% - Petit Verdot 5% - Cabernet Sauvignon 20% - Syrah 15% - Tannat 10%
Sight: Deep red purple.
Nose: Wafting aromas of red currants, black cherries and mildly smoky and sweet vanilla oak.
Mouth: Layers of currant fruit, dense black cherry and notes of brown spice (cocoa, nutmeg), dark chocolate, and hints of sandalwood. Keeps showing its complexity as it breathes in the glass. Perfect balance, great concentration and length, and loaded with fine, ripe tannins.

SERRERA TORRONTÉS

Blend: Torrontés 100%
Sight: Bright and clear with green hues.
Nose: Very elegant, with a lot of floral and citric notes.
Mouth: Fresh in mouth, long and round.