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 (
    12693, 11795, 2629, 11122, 2633, 2655, 
    11124, 2653, 2654, 11123, 2219, 2572, 
    2614, 2613, 15131, 2786, 2789, 2790, 
    11133, 11809, 2787, 2784, 2791, 2785
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00081

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": ["PRIMARY", "product_id"],
      "key": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (12693,11795,2629,11122,2633,2655,11124,2653,2654,11123,2219,2572,2614,2613,15131,2786,2789,2790,11133,11809,2787,2784,2791,2785) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2219 <ul><li>Drambuie is a whisky liqueur</li><li>A blend of aged Scotch whisky,spices, hers and heather honey</li><li>Its origins can be traced to a secret recipe created for Bonnie Prince Charlie by his Royal Apothecary in the 18th Century</li><li>The name Drambuie is derived from Scots Gaelic 'An Dram Buidheach' and means “The Drink that Satisfies”</li></ul>
2572 <ul><li>A light, dry white wine, made from 100% Chenin Blanc grapes, this is an easy drinking, low alcohol option for the health conscious and those watching their kilojoule intake</li><li>It is 25% lower in alcohol than most other white table wines</li><li>1 x 3L box </li></ul>
2613 <ul><li>A light, dry white wine, made from 100% Chenin Blanc grapes,this is an easy drinking, low alcohol option for the health conscious and those watching their kilojoule intake</li><li>It is 25% lower in alcohol than most other white table wines</li></ul>
2614 <ul><li>A light, dry white wine, made from 100% Chenin Blanc grapes, this is an easy drinking, low alcohol option for the health conscious and those watching their kilojoule intake</li><li>It is 25% lower in alcohol than most other white table wines</li><li>1 x 5L box </li></ul>
2629 <ul><li>A fruity dry white blend that is best enjoyed well chilled for easy anytime drinking</li><li>The perfect summer sundowner, picnic or beach wine that is delicious with almost any fish or seafood, roast chicken pie, creamy pasta or soft white cheese</li></ul>
2633 <ul><li>A bright crimson heart with deep ruby rim</li><li>Lashings of crushed summer berries and fleshy plum aromas with supple, succulent, generous ripe berry favours brushed with soft oak spice to a sleek juicy fruit finish</li></ul>
2653 <ul><li>Attractive crimson depth with a purple hue on the rim</li><li>Generous ripe strawberry and raspberry fruit on the nose brushed with dark chocolate and caramel hints</li><li>Plush and juicy on entry with an ample mouthful of juicy fruit well supported by soft, ripe tannins and discreet oak spice finishing with soft sleek cherry and berry flavours</li><li>Soft and fruity allowing immediate easy social enjoyment on its own or with smoked spicy sausages,meaty pasta dishes, lamb chops or cottage pie</li></ul> <p></p>
2654 <ul><li>Pale gold with a vibrant green tinge</li><li>Overt pineapple, gooseberry and granadilla aromas carry through to a crisp dry entry and a surge of tangy tropical flavours that finish with a feisty acidity and delicate citrus twang</li></ul>
2655 <ul><li>Bright garnet with a bright strawberry rim</li><li>Packed with juicy black cherry and fleshy plum aromas that tumble softly across the palate with plush mulberry and spice flavours interwoven with soft, ripe tannins and subtle oak intrique for a smooth and juicy finish</li></ul>
2784 <ul><li>This fruit-driven Chardonnay comes alive with citrus and lime flavours on the nose</li><li>Dried peaches, vanilla and subtle wood flavours carries through to the palate of this well balanced wine</li><li>Enjoy chilled on its own or with a selection of salads, seafood paella, fish, mild curry and chicken</li></ul> <p><br /></p> <p></p>
2785 <ul><li>The wine holds a complex range of flavours with gooseberry, pear and litchi aromas on the nose with a hint of asparagus</li><li>Beautifully balanced, the palate is smooth with a lingering, crisp finish</li><li>Enjoy chilled on its own or served with pasta, seafood, selection of cold meats, chicken and pork</li></ul>
2786 <ul><li>This fruity style Chenin Blanc erupts with flavours of apple, pear and pineapple and tropical fruit on the nose </li><li>The wine is medium-bodied with good balance between fruit, acidity and residual sugar ending with a crisp, pleasing taste on the palate</li></ul>
2787 <ul><li>This particular Shiraz reflects the area's unique terroir</li><li>Complex range of eucalyptus, spice, peppercorn and granadilla flavours is supported by subtle smoky undertones from eight months maturation in French oak</li><li>A well-balanced wine with supple tannins and smooth finish</li></ul>
2789 <ul><li>Shimmering, brassy gold with lime-green specks</li><li>Concentrated mass of crystallized and citrus fruit, intriguing botrytis hints, turning to chocolate orange liqueur on a silky palate</li><li>Exceptionally long, fruity aftertaste</li><li>Ideal with all desserts especially ice cream, baked puddings or as an after-dinner drink</li></ul> <p><br /></p> <p></p>
2790 <ul><li>A well rounded, medium-bodied wine with inviting raspberry and other ripe red berry flavours, hints of spice and dried banana</li><li>It has an impressive smoothness and a long fruity finish</li><li>An ideal companion with BBQ and other red meat dishes. Also lovely with smoked chicken</li></ul> <p></p>
2791 <ul><li>Dark ruby in colour, this wine offers aromas of ripe plums, cherries, chocolate and a slight scent of dried banana, all wrapped in sweet, oaky vanilla</li><li>Dry, supple tannins add to a silky mouth-feel of black cherries</li><li>Enjoy now or drink within three years of bottling</li></ul> <p><br /></p> <p></p>
11122 <ul><li>Bright gold with a youthful green glow</li><li>Brimming with a fruit salad of aromas including tropical pineapple, papaya, guava and granadilla with a subtle streak of green asparagus and figs that follow through on an accommodating mouthful of sunny ripe flavours, perfectly balanced by a frisky dry finish with lingering citrus freshness</li><li>A fruity dry white blend that is best enjoyed well chilled for easy anytime drinking</li><li>The perfect summer sundowner, picnic or beach wine that is delicious with almost any fish or seafood, roast chicken pie, creamy pasta or soft white cheese</li></ul> <p></p>
11123 <ul><li>An irresistible juicy natural sweet rosé, Douglas Green Sunkissed Rosé is a pretty cherry pink with tempting crushed strawberry and Turkish delight aromas that explode in succulent candied red berry flavours</li><li>The light alcohol makes this easy drinking and a great lunch time wine.</li></ul>
11124 <ul><li>Sink into this deliciously smooth and juicy red blend packed with succulent summer berry aromas that make way to a sumptuous mouthful of sweet juicy plums and soft oak spice flavours</li><li>Chill slightly in summer for effortless social sipping or cosy up with it in winter around a roaring fire</li></ul> <p></p>
11133 <ul><li><b>Medium pink in colour with raspberry, strawberry, red berry and tart cherry flavours</b> that carry through to a perfectly balanced palate</li><li>Medium pink in colour with raspberry, strawberry, red berry and tart cherry flavours that carry through to a perfectly balanced palate</li></ul>
11795 <p>DOUGLAS GREEN WINE CHARDONNAY 1 x 750ML (1S)</p>
11809 <p>DU TOITSKLOOF 750ML PINOTAGE ROSE WINE 1 x 750ML (1s)</p>
12693 <p>DOUGLAS GREEN VINEYARD FRIENDS SAUVIGNON BLANC 1 x 750ML (EA)</p>
15131