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 (
    12669, 12975, 2299, 2297, 2298, 2203, 
    2566, 3215, 3214, 11118, 12685, 13990, 
    2340, 11888, 2339, 2338, 2180, 2181, 
    13661, 15141, 2228, 2226, 2227, 2336, 
    12743, 2185, 14298, 15154, 13222, 15155
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00062

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": 30,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (12669,12975,2299,2297,2298,2203,2566,3215,3214,11118,12685,13990,2340,11888,2339,2338,2180,2181,13661,15141,2228,2226,2227,2336,12743,2185,14298,15154,13222,15155) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2180 <ul><li>Jägermeister is <b>a German bitter-sweet liqueur made from 56 varieties of herbs, fruits and spices</b></li><li>Macerated in spirit for up to six weeks and then matured in oak before blending</li><li>Jagermeister tastes herbal and complex, it's thick and syrupy, with <b>strong anise or black licorice notes on the finish</b></li></ul>
2181 <ul><li>Jägermeister is <b>a German bitter-sweet liqueur made from 56 varieties of herbs, fruits and spices</b></li><li>Macerated in spirit for up to six weeks and then matured in oak before blending</li><li>Jagermeister tastes herbal and complex, it's thick and syrupy, with <b>strong anise or black licorice notes on the finish</b></li></ul> <p></p>
2185 <ul><li>Deep golden amber color with b<b>uttery caramel and golden raisin aromas</b></li><li>A soft entry leads to a dryish light-to-medium of honeyed grain and bread dough flavors with a delicate peppery slate accented fade</li></ul>
2203 <ul><li><b>Inspired by an Italian</b>, created in London and distilled in Scotland, J&B Rare is unlike any other Scotch whisky</li><li>It brings together 42 single malt and grain whiskies and carefully blends them to create a subtle, smooth and complex flavour</li></ul>
2226 <ul><li>Jameson brings a <b>light floral fragrance on</b> the nose, peppered with spicy wood and sweet notes before an exceptional balance of spicy, nutty and vanilla tones on the palate</li><li>Hints of sweet sherry that develop into an incredibly smooth and mellow finish</li></ul> <p></p>
2227 <ul><li>Jameson brings a <b>light floral fragrance on</b> the nose, peppered with spicy wood and sweet notes before an exceptional balance of spicy, nutty and vanilla tones on the palate</li><li>Hints of sweet sherry that develop into an incredibly smooth and mellow finish</li></ul> <p></p>
2228 <ul><li>This Irish whiskey is a blend of <b>12-year pot-</b>still whiskey and 5-year grain whiskey</li><li>It's aged in extra-charred bourbon barrels and non-chill filtered</li><li>This Jameson expression is also believed to be the international version of their Select Reserve Black Barrel, which is only available in the US</li></ul>
2297 <ul><li>Infused with fynbos from the limestone-rich soils of the low lands of the Cape Floral Kingdom</li><li>Inverroche Gin Classic is <b>crispy and dry with upfront green, grassy juniper notes</b> which blend seamlessly with a bouquet of soft flowers on the nos</li></ul>
2298 <ul><li>Inverroche Verdant Gin employs huge amounts of fynbos from the mountainous regions of South Africa</li><li>It's <b>full of waxy herbal flavours</b>, with soft florals and sweet chamomile</li><li>It's a totally unique gin, best served with Elderflower Tonic</li><li>After distillation, an extra dose of fynbos is infused into the gin</li></ul>
2299 <ul><li>Infused with fynbos from the coastal region and dunes of the Cape Floral Kingdom</li><li>Inverroche Gin Amber is a <b>rich and aromatic, amber coloured gin</b> with fresh citrus, slight juniper, sweet toffee apples and delicate floral notes which intertwine to deliver a dry, woody finish</li></ul>
2336 <ul><li>Jim Beam white label is <b>Beam's flagship bourbon</b> and their best selling product</li><li>Corn, light fruit and alcohol pretty much sum the nose up on this one</li><li>Corn and vanilla are present but overall the finish leaves little impression on you</li></ul>
2338 <ul><li>A <b>blend of Jack Daniel's Tennessee Whiskey and a unique honey liqueur of our own making</b>, for a taste that's one-of-a-kind and unmistakably Jack</li><li>With hints of honey and a finish that's naturally smooth, Jack Daniel's Tennessee Honey offers a taste of the unexpected</li></ul>
2339 <ul><li>Our Tennessee Fire <b>blends warm cinnamon liqueur with the bold character of Jack Daniel's Old No.</b> <b>7</b> for a classic spirit with a surprisingly smooth finish</li><li>Sometimes, mixing fire and whiskey is a good thing</li><li>Our Tennessee Fire blends warm cinnamon liqueur with the bold character of Jack Daniel's Old No 7</li></ul>
2340 <ul><li>A pleasant <b>mix of fruity sweetness, vanilla custard, oak, and banana</b></li><li>It's medium in intensity, yet still has a decent richness to it Apricot and corn provide an additional layer of nuance</li></ul>
2566 <ul><li>J.C Le Roux Non-Alcoholic Le Domaine Sparkling Wine is made with the same care and dedication as the rest of the Vivante range</li><li>A crisp freshness comes alive on the palate with a gentle sweetness and an upfront fruitiness</li></ul>
3214 <ul><li>J.C. Le Roux Le Domaine is a <b>bright, green-yellow sparkling wine</b> which has a bubbling muscat aroma supported by cheerful fruit flavours on the nose</li><li>The palate is alive with sweet tropical fruits in perfect harmony with natural fruit acids supported by an enjoyable aftertaste</li></ul>
3215 <ul><li>J.C. Le Roux La Chanson is a <b>lively, ruby-red sparkling wine</b></li><li>It reveals a delightful mélange of sweet, fruity flavours suggesting hints of strawberry and plum</li><li>This sparkling wine is made predominantly of Pinotage grapes blended with other red varieties such as Shiraz and Cabernet Franc</li></ul>
11118 <ul><li>Nectar Demi-sec is a <b>sophisticated, off-dry, sparkling wine</b> that comes alive on the palate</li><li>It is a vibrant expression of fruity flavours with hints of pears, litchi and primary fruit</li></ul>
11888 <p>Jack Daniels Bourbon Whisky - Single Barrel - 1 x 750 ml </p>
12669 ICE TROPEZ 275ML FRENCH ROSE WINE BASED C\TAIL 6.5% 6 x 275ML
12685 J.C.LE ROUX SPARK WINE DEMI SEC NECTAR ROSE 1 x 750ML (EA)
12743 <p>Johnnie Walker Black Label <b>rolls decadently over the tongue, releasing intense sweet vanillas that give way to orange zest and aromas of spice and raisins</b>. The finish is unbelievably smooth and layered with rich smoke, peat and malt</p>
12975 <p>Bright tropical fruit aromas lead to a crisp, fresh palate with mouth-filling flavors of vibrant tropical fruit aromas. Enjoy a mouth-filling palate with flavors of apple, pear, honey and pineapple. A whisper of oak adds a creamy butterscotch nuance and wonderful depth.</p>
13222
13661 <ul><li>This Irish whiskey is a blend of <b>12-year pot-</b>still whiskey and 5-year grain whiskey</li><li>It's aged in extra-charred bourbon barrels and non-chill filtered</li><li>This Jameson expression is also believed to be the international version of their Select Reserve Black Barrel, which is only available in the US</li></ul>
13990
14298
15141
15154
15155