SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    2686, 2568, 15042, 14456, 2188, 13664, 
    12195, 14044, 15057, 12955, 2645, 2646, 
    2333, 2331, 2330, 2792, 2793, 11131, 
    2794, 11132, 2798, 2795, 2797, 11890
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00066

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "product_id",
      "key_length": "3",
      "used_key_parts": ["product_id"],
      "rows": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (2686,2568,15042,14456,2188,13664,12195,14044,15057,12955,2645,2646,2333,2331,2330,2792,2793,11131,2794,11132,2798,2795,2797,11890)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2188 <ul><li>A combination of rich sweetness with a smoky dryness and appetising spice distinguishes this lovingly-matured Highland malt</li><li> Well-paced, beautifully textured, and sweetly generous Oban</li><li>The warming richness is neatly balanced by a smoky spicy-dryness; perfect with a chocolate truffle or two</li><li>An immediate and assertive, complex, and evocative nose, well balanced and well-structured throughout with layers of classic Oban fruit and malt, introduces an equally well-balanced palate that starts richly coating then grows dryer and more cleansing, before a long and oaky finish</li><li>Serving Suggestion: Best served neat in a tumbler, perhaps with a little cool spring water</li><li>Appearance: Olive gold. Body: A full, rich, almost oily malt</li><li>Nose: Immediate and confident; rapidly gaining intensity</li><li>Warming and sweet: oily, waxy and nutty, balanced by delicate ripe orchard fruits</li><li>At once cleansing yet chewy, with just a trace of late, slightly cedary, smoke</li></ul> <p></p>
2330 <ul><li>It is a <b>high-quality mixto tequila</b> with a unique production process that combines hand picked agave plants, masonry oven, cultivated yeast and distillation in small copper pot stills</li><li>The aroma of the Olmeca reposado is fruity, sweet and citric with a touch of smoke and slightly woody</li></ul>
2331 <ul><li>Olmeca Dark Chocolate is a <b>delicious combination of cocoa beans, dark chocolate, and tequila</b> from the province of Jalisco in Mexico</li><li>It has a smooth, silk-like texture that perfectly combines the rich dark chocolate flavour balanced with a dash of tequila for a smooth and effortless drinking experience</li></ul>
2333 <ul><li>Olmeca Blanco a tequila <b>with intense, fruity aromas</b>, combining fresh green citrus with ripe sweet fruits and cooked agave, and is ideal for refreshing cocktails</li></ul>
2568 <ul><li><b>Clear, luminous with green tints of a</b>romas of citrus and flowers (violets) with spicy undertones of aniseed and cloves</li><li>Youthful but full on taste with a complex mouth-feel and long aftertaste</li></ul>
2645 <ul><li>The Juliette is made from <b>100% Sauvignon Blanc</b> and has her roots in the shale soils of the stunning Highfield farm in Elgin, in a vineyard farmed for premium wine</li><li>This attention to detail yielded a lively wine, with crushed pineapple, bananas and soft tropical notes of white peaches and pear on the nose</li></ul>
2646 <ul><li>Shiraz shines in this exciting combination with its spicy smokiness and flavours of ripe berries, Pinotage adds an unmistakable contribution to the blend, rounded off with a touch of Mourvedre</li><li>A great accompaniment to grilled beef mutton or venison</li><li>In fact, it's a must for meat</li></ul>
2686 <ul><li>A medium-bodied structure with classic cabernet-fruit characteristics of blackberries</li><li>Slight herbaceousness and soft tannins make this wine extremely elegant and easy to enjoy</li><li>The peppery character follows through from the nose onto the palate</li><li>The finish lingers on</li></ul>
2792 <ul><li>A <b>refreshingly well-balanced wine with zesty flavours of gooseberry, pear and melon</b></li><li>An ideal accompaniment to grilled fish, chicken and summer salads</li></ul>
2793 <ul><li>A <b>light yellow coloured wine with abundant fruit flavours on the nose</b></li><li>Delicately sweet on the palate and well balanced</li><li>The ideal companion to spicy meals</li></ul>
2794 <ul><li><b>Ripe fruit and chocolate aromas and flavours</b> with a seductive juiciness, supported by smooth tannins</li><li>Enjoy with barbecued meat, pizza or pasta dishes</li></ul>
2795 <ul><li>This sweet rosé sparkling wine effervesces with Turkish delight flavors on the pallet and yet remains crisp and fresh</li><li>The nose is full of strawberries and cream, with <b>has hints of muscat and roses</b></li><li>Great for any celebration or whenever the need to be festive arises</li></ul>
2797 <ul><li>This sweet sparkling wine effervesces with fruit flavors on the pallet and yet <b>remains crisp and fresh</b></li><li>The nose is mostly tropical, but has hints of muscat and guava</li></ul>
2798 <ul><li>This dry sparkling wine has a <b>wonderfull creamy texture with notes of butter on the nose</b></li><li>The palate is full and fruit driven, with an acidity that promotes the freshness of the noble cultivars that were harvested early in the season</li></ul>
11131 <ul><li><b>Deep red colour with aromas of raspberries, blackcurrant and nutmeg jumping out of the glass</b></li><li>Enjoy with barbecues, stews, pizza or pasta dishes</li><li>Serve at room temperature</li></ul>
11132 <ul><li>Pronounced savoury and spicy aromas, followed by rich concentrated flavours of blackberry and prunes</li><li>Enjoy with roast meats, venison and hearty stews</li><li>Serve at room temperature</li></ul> <p><br /></p> <p></p>
11890 <p>Orijin Gin - Marula - 1 x 750 ml </p>
12195 <p>Okavango Gin is a celebration of the world’s wild, pure and natural places. A celebration that connects you with these places. A connection we hope will provide some inspiration for their continued protection.  </p> <p>From a 100% off-grid distillery located in the Okavango Delta, we distill world class gin using inputs unique to one of the world's great wilderness areas. At the same time, with your help, we strive to create genuine employment opportunities for residents of the nearby village of Tsutsubega and surrounding areas.  </p> <p>The Sentinel is a contemporary dry gin with a perfect blend of fresh citrus and woody notes. Botanicals are soaked in alcohol for 12 hours before distillation to extract the most delicate oils. It is then distilled using a traditional alembic copper pot still before it is blended with pure Okavango water, to achieve perfect bottling strength.  </p> <p>Without a doubt, the Sentinel’s star ingredient is the Mopane seed, with flavour properties closely resembling those of the juniper berry, providing its signature dry, earthy and rustic flavour. </p> <p>Inspired by Nature, from source to sunset, Okavango Gin is more than a Gin, it’s a celebration. Pula! </p> <p></p>
12955 <p><strong>ABV</strong>: 4% I <strong>IBUs</strong>: 39</p> <p>Named after the stereotypical old bull found throughout the Okavango Delta, that is mature and has no boundaries. This is a creamy Irish Stout with dense aromas of roast coffee, dark chocolate and an assertively bitter hop finish.</p>
13664 <p>Historically fed by waters of the Okavango, the Makgadikagdi salt pans once formed a giant paleolake, whose ancient silcrete sediments stores above it an abundance of pure prehistoric water: a lifeline to the landscape above. Today, these dry salt pans transition into productive woodlands dominated by Marula trees that produce ample fruit in late summer. Baboons, on a never ending forage, wander far and wide in search of this nutritious treat.<br /></p> <p>Nestled within these woodlands lies the village of Gweta. The women here brew traditional beer “Bojalwa ja Morula” made from the Marula fruit using an age old technique. After sun ripening they add pulp and seed to spring water for the brewing process, before finally straining the beer through hand woven grass sieves. This is used for the initial distillation of this Marula Gin.</p> <p>The Forager is a seasonal limited batch gin. Once brewed in the Kalahari Desert and twice distilled in the Okavango Delta. A blend of pure Okavango water, coupled with the robust citrus notes of the Marula fruit and the distinct fingerprint flavour of the Mopane seed, create this vibrant, contemporary gin. Pula!</p>
14044 <p>Okavango Gin is a celebration of the world’s wild, pure and natural places. A celebration that connects you with these places. A connection we hope will provide some inspiration for their continued protection.  </p> <p>From a 100% off-grid distillery located in the Okavango Delta, we distill world-class gin using inputs unique to one of the world's great wilderness areas. At the same time, with your help, we strive to create genuine employment opportunities for residents of the nearby village of Tsutsubega and surrounding areas.  </p> <p>The Sentinel is a contemporary dry gin with a perfect blend of fresh citrus and woody notes. Botanicals are soaked in alcohol for 12 hours before distillation to extract the most delicate oils. It is then distilled using a traditional alembic copper pot still before it is blended with pure Okavango water, to achieve perfect bottling strength.  </p> <p>Without a doubt, the Sentinel’s star ingredient is the Mopane seed, with flavour properties closely resembling those of the juniper berry, providing its signature dry, earthy and rustic flavour. </p> <p>Inspired by Nature, from source to sunset, Okavango Gin is more than a Gin, it’s a celebration. Pula! </p> <p></p>
14456
15042
15057