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 (
    2573, 2596, 14660, 15280, 14647, 13644, 
    15393, 15124, 12954, 2702, 2313, 11853, 
    13610, 13444, 12710, 2584, 13445, 11811, 
    2818, 11813, 11812, 2817, 2820, 2821
  ) 
  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": "PRIMARY",
      "key_length": "9",
      "used_key_parts": ["product_id", "lang_code"],
      "rows": 24,
      "filtered": 100,
      "index_condition": "cscart_product_descriptions.product_id in (2573,2596,14660,15280,14647,13644,15393,15124,12954,2702,2313,11853,13610,13444,12710,2584,13445,11811,2818,11813,11812,2817,2820,2821) and cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2313 <ul><li>Also known as silver tequila, this variety has a bold flavor that may be too harsh for some palates</li><li>Since it's not aged, this drink features grassy <b>herbal notes</b> with hints of citrus, black pepper and spices</li><li>The sweetness from the agave rounds out the flavour, which makes it a great fit for mixing into cocktails</li></ul>
2573 <ul><li>This wine is <b>crisp and fresh with fresh fruit flavours and undertones of dried fruit</b></li><li>On the palate it is well balanced with a delicate freshness and a refreshing, fruity taste</li><li>1 x 5L box </li></ul> <p><br /></p> <p><br /></p>
2584 NEDERBURG WINE ROSE 1 x 750ML (1S)
2596 <ul><li>The wine has <b>pronounced ripe fruit flavours with a spicy background</b></li><li>On the palate it is well balanced with delicate tannins and a lingering aftertaste</li><li>1 x 5L Box </li></ul> <p><br /></p>
2702 <ul><li>A <b>Super value dry sparkling wine with w</b>hiffs of citrus, peach and apple</li><li>Succulent, dry finish</li><li>Enjoy as an aperitif or to complement oysters, shellfish or other seafood-dishes</li></ul>
2817 <ul><li>A deep purple Shiraz with a <b>fusion of dark plum, blackberry and white pepper flavours</b></li><li>A rich palate with intense fruit and enticing spice characters, complemented by a dash of well-integrated oak followed with a lingering aftertaste</li></ul>
2818 <ul><li>A <b>tropical nose with guava, fruit salad and kiwifruit</b></li><li>The palate is fresh and crisp. Enjoy with seafood; salads; lightly flavoured pasta, pizza</li></ul>
2820 <ul><li><b>Soft tannins and ripe, dark fragrantly sweet fruit</b></li><li>A touch of oak adds complexity and substance to a very juicy body</li></ul> <p><br /></p>
2821 <ul><li><b>Bright Salmon Pink with </b>hints of fresh berries, cherries and candy floss on the palate</li><li>It is fresh and sweet with a smooth finish</li></ul>
11811 <ul><li>A <b>dark purple Cabernet</b>, with a blackcurrant and cherry nose</li><li>The palate experiences dark fruit and hints of vanilla</li><li>The aftertaste is long and smooth. Lamb curry; roast beef or steak are excellent partners with this wine</li></ul>
11812 <ul><li>A <b>tropical nose with freshly cut grass, asparagus and hints of bell pepper</b></li><li>The palate experiences a fresh, crisp acidity</li><li>Enjoy with salads; seafood, lightly flavoured pasta, pizza</li></ul>
11813 <ul><li>Elegant and fruity, this easy drinking red has <b>lovely soft tannins</b> and a long finish</li><li>The intense, almost purple colour of this wine reflects juicy berry and plum flavours, which are nicely balanced with a touch of spiciness</li><li>The wine's soft tannins and long finish make it the perfect partner for rich, meaty dishes</li></ul>
11853 <p>We didn’t invent tequila, we just perfected it. Our passion for excellence, quality and perfection guides everything we do. We maintain our consistent high quality by replicating the original small batch process many times over. PATRÓN is made from only the finest, highest-quality Weber Blue Agave, which gives it its characteristic smoothness and layers of flavor. </p>
12710 <p>PERDEBERG LIGHTHEARTED CINSAULT ROSE 1 x 750ML (EA)</p>
12954 <p><strong>ABV</strong>: 4.5% I <strong>IBU</strong>: 25</p> <p>This Pale Ale is named after the primary millet growing region in the Panhandle area of the Okavango. The beer reflects a true balance between malty, bready, caramel notes and a mildly bitter spicy hop aroma.</p>
13444 <p>The crimson hue and lovely berry fragrance on this natural rosé are a pleasure for the senses. It's an easy drinking wine that's suitable enjoyed solo or in a crowd.</p>
13445 <p>This wine pairs excellent with summer favourites like a summer berry salad with grilled chicken or greek yogurt panna cotta with strawberry sauce.</p>
13610 <p>Aquarite's Peach Flavoured Iced Tea. </p><p>12 x 500ml pack</p>
13644 <p>Painted Wolf The Den Pinotage 2021 750ml</p>
14647 <p></p><ul><li><b>Grape Variety</b>: 100% Chenin Blanc</li><li><b>Vineyard Location</b>: Western Cape, South Africa</li><li><b>Vineyard Management</b>: Sustainable farming practices</li><li><b>Harvesting</b>: Grapes are hand-harvested at the peak of ripeness to ensure optimal flavor concentration</li><li><b>Fermentation</b>: Fermented in stainless steel tanks under controlled temperatures to preserve the varietal’s characteristic freshness</li><li><b>Aging</b>: Aged on lees to add complexity and texture</li><li><b>Alcohol</b>: 13.5&gt;#/li###</li><li><b>Bottling</b>: Bottled at the winery to maintain quality and consistency</li></ul>
14660
15124
15280
15393