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 (
    11912, 11913, 11904, 11905, 11915, 11914, 
    11917, 11916, 15106, 15071, 11664, 
    2616, 2615, 2552, 11121, 2570, 2617, 
    2618, 2703, 2706, 2708, 2701, 2329, 
    12686
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00083

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 (11912,11913,11904,11905,11915,11914,11917,11916,15106,15071,11664,2616,2615,2552,11121,2570,2617,2618,2703,2706,2708,2701,2329,12686)",
      "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>
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>
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>
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>
11904 <ul><li>Fitch & Leedes - Lemonade  - 24 x 200 ml</li></ul>
11905 <ul><li>Fitch & Leedes - Lemonade  - 6 x 200 ml</li></ul>
11912 <ul><li>Fitch & Leedes - Indian Tonic - 24 x 200 ml </li></ul>
11913 <ul><li>Fitch & Leedes - Lemonade  - 1 x 750 ml</li></ul>
11914 <ul><li>Fitch & Leedes - Sparkling Pink Tonic - 6 x 200 ml</li></ul>
11915 <ul><li>Fitch & Leedes - Sparkling Pink Tonic - 24 x 200 ml</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)
15071
15106