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 (
    11917, 11916, 15106, 15071, 11664, 2616, 
    2615, 2552, 11121, 2570, 2617, 2618, 
    2703, 2706, 2708, 2701, 2329, 12686, 
    12687, 11800, 11801, 2738, 2739, 2740, 
    2737, 2845, 2643, 12708, 12707, 2347
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

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": 30,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (11917,11916,15106,15071,11664,2616,2615,2552,11121,2570,2617,2618,2703,2706,2708,2701,2329,12686,12687,11800,11801,2738,2739,2740,2737,2845,2643,12708,12707,2347)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2329 <ul><li>Light amber in color, Frangelico has a lush, toasty flavour, with hints of vanilla and white chocolate, as well as complec herbal flavours</li><li>As legend goes, Frangelico is based on a seventeenth-century liqueur made with hazelnuts and local herbs by Christian monks in the Piedmont hills of Northern Italy</li></ul>
2347 <ul><li>Galliano is made from a special blend of 30 herbs, such as star anise, juniper, lavender, yarrow musk and vanilla, with a process of seven infusions and six distillations creating a deliciously complex, intense yet mellow taste at 43.2% ABV</li><li>Galliano's golden yellow color commemorates the California Gold Rush</li></ul>
2552 <ul><li>The wine is brilliantly clear</li><li>he nose is fresh with intense aromas of citrus, apples and a stone fruit with a touch of oak spice, carried through to the palate The time spend on the lees adds to the creaminess and roundness of the wine</li><li>It has a lingering crispy finish</li></ul>
2570 <ul><li>With an alcohol level of 9,7%, Fleur du Cap Natural Light Rosé 2015 is a palate friendly wine, ideal for enjoying with family and friends</li><li>Made predominantly of Chenin Blanc grapes, this Rosé has subtle notes of pear and pineapple, with just enough acidity to add a burst of freshness</li></ul>
2615 <ul><li>This medium bodied Chardonnay is brilliantly clear with light straw yellow hue and green tints</li><li>Fresh citrus notes are prominent on the nose and it opens up into tropical fruit aromas and just a hint of oak spice</li><li>This is a fruit driven wine with a lovely balance between acidity and fruit</li></ul>
2616 <ul><li>This full-bodied wine has a ruby red color with aromas of ripe berries and cherries, hints of pencil shavings ending in subtle oak spices</li><li>On the palate this well-balanced wine is velvety soft yet mouth filling with clean soft fruit and elegant oak spice with gentle tannins</li></ul>
2617 <ul><li>This wine has a deep red colour with crimson edges </li><li>On the nose it shows ripe fruit such as plums and a hint of black currant, finishing in oak spice</li><li>Full-bodied on the palate with ripe plum and other berries standing out</li><li>The Pinotage is very well balanced with a lingering after taste</li></ul>
2618 <ul><li>The wine is brilliantly clear with green tinges </li><li>There is an abundance of tropical aromas on the nose with fl oral and herbaceous undertones</li><li>This is an elegantly balanced wine with concentrated flavours of passion fruit, lime and melon on the palate</li></ul>
2643 <ul><li>An especially enticing wine</li><li>A fantastic nose of vanilla, cumin, white pepper</li><li>Aftertaste of dried pear and apple </li></ul> <p></p>
2701 <ul><li>Four Cousins Natural Sweet Rose, a fragrant,flame-coloured wine with gentle floral perfume <b></b></li><li>Flavours of luscious tropical fruits, peaches & raisins are followed by a lingering, silky finish</li><li>1 x 1.5 l bottle </li></ul> <p><br /></p>
2703 <ul><li>A pleasant, fruit-filled unwooded red wine with ripe summer berries on the nose, followed by soft spices on the gently lingering palate</li><li>A wine for everyday enjoyment</li><li>Enjoy with red meat dishes, flavourful stews, barbecue, roast chicken and cheese platters</li><li>1 x 1.5 L bottle </li></ul>
2706 <ul><li>A well-balanced, harmoniously blended blended, crisp white wine<b> </b>with cheerful tones of tropical fruit and peaches on the nose and gently lingering palate</li><li>Enjoy as an aperitif, spicy oriental food, fruit and desserts</li><li>1 x 1.5 L bottle </li></ul>
2708 <ul><li>A fragrant, ruby=red wine with soft rose petal perfume </li><li>Flavours of ripe plums, strawberries, and exotic spices are followed by a soft, lingering finish</li><li>1 x 1.5 l bottle </li></ul> <p></p>
2737 <ul><li>Taking its name from the graceful monument built in honour of the French Huguenots</li><li>This elegant Sauvignon Blanc has delectable tropical flavours tinged with capsicum, balanced acidity and a fresh, lingering finish</li></ul>
2738 FRANSCHOEK 750ML WINE CELLAR SHIRAZ 1 x 750ML (1S)
2739 <ul><li>Franschhoek Cellar Churchyard Cabernet Sauvignon is a wine with great presence and poise</li><li>The 2018 vintage shows blackcurrants and violets on the nose, followed by concentrated dark berry flavours integrated with tobacco and spice from savoury oak, a lovely a rich mouthfeel, and a smooth and juicy-lingering finish</li></ul>
2740 <ul><li>Our Merlot pays homage to the rich settler history preserved by the old town museum</li><li>It is soft and juicy with attractive plum<b> </b>and black cherry aromas intertwined with herbal tea, liquorice and gentle oak spice</li></ul>
2845 <ul><li>An especially enticing wine</li><li>A fantastic nose of toffee apple, ripe plum, dark cherry, with white chocolate</li><li>Flavours of poached plum, vanilla, cumin, white pepper with smooth tannins in a medium bodied wine</li><li>Aftertaste of dried pear and apple</li></ul>
11121 <ul><li>This full-bodied, ruby coloured red has aromas of dark chocolate,black cherry and plums underlined by elegant wood spices</li><li>On the palate this well-balanced wine is velvety soft yet mouth fi lling with clean soft fruit and a touch of sweet oak</li></ul>
11664 <p>Fitch & Leeds (Soda Water) 200ml x 24 cans</p>
11800 FRANSCHOEK 750ML WINE CELLAR CHENIN BLANC 1 x 750ML (1S)
11801 <ul><li>Generous aromas of black cherry, clove and raspberry jam</li><li>A smooth and juicy palate is redolent of ripe mulberry, glimmers of tobacco and spice for a savoury finish</li></ul>
11916 <ul><li>Fitch & Leedes - Pink Tonic - Sugar Free - 6 x 200 ml</li></ul>
11917 <ul><li>Fitch & Leedes - Pink Tonic - Sugar Free - 24 x 200 ml  </li></ul>
12686 FRANSCHHOEK CELLAR BRUT ROSE NV 1 x 750ML (EA)
12687 <p>FRANSCHHOEK CELLAR CELLAR BRUT ROYALE 1 x 750ML (EA)</p>
12707 FREYERS COVE DORINGBAY SAUV BLANC 1 x 750ML (EA)
12708 FREYERS COVE DORINGBAY PINOT NOIR 1 x 750ML (EA)
15071
15106