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 ('2245', '2365', '2573') 
LIMIT 3

Wine Guide

White Blend Sparkling Rosé Red

Some Wines

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

EXPRESIONES SHIRAZ CABERNET SAUVIGNON 2009

Blend: Shiraz 60% - Cabernet Sauvignon 40%
Sight: Deep red color
Nose: Black fruits, some pepper and elegant oak
Mouth: Full bodied with a concentration of fruits and spices

DON VALENTIN LACRADO

Blend:
Sight: Intense red-maroon color.
Nose: Its aromas reminds of ripe red fruits like black cherry and wild blackberries.
Mouth: In the mouth it has a pleasant entry with a long fruity after taste that extends the tasting experience.