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 (
    2825, 2303, 2302, 2562, 2563, 2564, 11788, 
    2343, 11790, 12698, 2268, 2269, 2316, 
    4395, 2315, 2626, 2624, 11804, 11803, 
    2842, 2741, 12711, 12697, 11802, 2255, 
    2256, 2383, 2380, 12657, 2321
  ) 
  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 (2825,2303,2302,2562,2563,2564,11788,2343,11790,12698,2268,2269,2316,4395,2315,2626,2624,11804,11803,2842,2741,12711,12697,11802,2255,2256,2383,2380,12657,2321)",
      "attached_condition": "cscart_product_descriptions.lang_code = 'en'"
    }
  }
}

Result

product_id short_description full_description
2255 <ul><li>Amarula is a cream liqueur from South Africa </li><li>It has a sweet and creamy taste</li><li>The fruit has a citrusy and creamy flavour and fibrous white flesh under its hard skin</li></ul> <p></p>
2256 <ul><li>Amarula is a cream liqueur from South Africa </li><li>It has a sweet and creamy taste</li><li>The fruit has a citrusy and creamy flavour and fibrous white flesh under its hard skin</li></ul> <p></p>
2268 <p><br /></p> <ul><li>A Mari Atlantic Ocean Gin draws its flavours from the West Coast of Cape Town</li><li>Inspired by the icy Atlantic Ocean and distilled with indigenous Cape coastal Fynbos</li><li>Nose: Fresh citrus forward, juniper, florals</li><li>Palate: Fresh citrus merging into mid of rich florals </li><li>Finish: long and smooth with a slight minerality</li><li>Botanicals: Juniper, Coriander, Orange, Tangerine, Lemon, Cardamom, Allspice, Angelica, a secret selection of cape coastal Fynbos</li></ul> <p><br /></p>
2269 <ul><li>A Mari Indian Ocean Gin draws its flavour from the East Coast of Africa. Inspired by the warm Indian Ocean and distilled with fragrant East African botanicals</li><li>Fragrant and gently spiced, this gin features Swahili Lime and Madagascan Pink Peppercorns</li><li>After distillation it is infused with Chai Masala which gives it its distinctive golden colour</li><li>Nose: rich and  fragrant, gentle spice </li><li>Palate: complex, Swahili lime and sweet ginger</li><li>Finish: long and mellow with a slight hint of tea on the finish</li><li>Botanicals: Juniper, Coriander, Swahili lime, Lemon, Swahili lime leaves, Ajwain seed, Madagascan pink peppercorns, Turmeric, Cardamom, Angelica. amari amari amari amari</li><li> Post distillation, infused with Chai: Kenyan black tea, Cinnamon, Black pepper, Ginger, Cloves, Ginger</li></ul> <p></p>
2302 <ul><li>Made from 11 unique botanicals and infused rosewater, 48 Gin is a product that is more than the sum of its ingredients, it’s a South African success story, savoured by those who are true high rollers</li><li>A soft and pleasant savoury aroma dominates this gin while juniper takes a backseat</li><li>Honey dew, vanilla and caramel notes lends a sweeter dynamic while soft citrus and mineral complexity adds to produce a very inviting gin</li><li>&nbsp;On the palate a sweet and savoury taste soon gives way to warm but very well integrated alcohol</li><li>A relatively short body with lingering orris root makes for a versatile mixing gin - in tonic or bitter lemon, the spirit has a high drinkability</li><li>A modern interpretation of a classic dry gin</li></ul> <p><br></p>
2303 <ul><li>Juniper notes comes forward on the nose but equally matched by floral, rose aromas</li><li>Underneath an assortment of pepper, corriander seeds, cardamon and angelica root</li><li>A smoothly integrated alcohol gives the interpretation of a sweeter liquid</li><li>Flowers are quickly replaced with a mild peppery bite and rich coffee flavours</li><li> Turkish delight lingers on the palate</li><li>Mixing with tonic water gives a more complex, sophisticated and elegant cocktail</li><li>Versatile enough to enjoy at a casual occasion</li></ul> <p><br /></p>
2315 <ul><li>Enjoy Absolut Raspberri – a premium raspberry flavoured vodka with the fresh and fruity character of ripened raspberries</li><li> Try neat or in your favorite cocktail</li></ul>
2316 <ul><li>Absolut Elyx is made using a vintage copper column still from 1921</li><li>Thousands of copper packets are used sacrificially, removing unwanted compounds and contributing to a rich final product</li><li>The skill and experience of manually operated distillation produces a luxury vodka with unparalleled character and flavor</li><li>Clean, rich, rounded, fresh bread and notes of white chocolate and light cereal and with a deep mellow spice</li><li>Full bodied, luscious silky mouthfeel with waves of rich macadamia nuts, creamed cereal and garnishes of white chocolate and buttery notes of freshly baked bread</li><li>Light fresh nuttiness with a well-balanced hint of mellow spice and pure balanced richness</li><li>Rounded mellow spice with fresh nuttiness and a well balanced warm smooth finish</li></ul> <p><br /></p> <p><br /></p> <p><br /></p>
2321 <ul><li>A concentrated bitters made of herbs and spices by House of Angostura in Trinidad and Tobago</li><li>Extracts of grasses, roots, leaves and fruits dissolved in alcohol</li><li>Ideal for balancing alcoholic drinks, cleansing the palate and facilitating digestion</li></ul>
2343 <ul><li></li></ul>
2380 <ul><li>Amstel is a <b>crisp tasting premium lager</b>, perfect for your next get-together with family or friends</li><li>For 150 years, Amstel has brewed a high quality beer that has the perfect balance of taste and refreshment</li><li>With a unique honey malt aroma, Amstel delivers a subtle citrus and herbal hop character with a clean finish</li></ul><p><br /></p> <p></p>
2383 <ul><li>Amstel Light is brewed in Amsterdam, part of brewing tradition that dates back to 1870. At just 95 calories per bottle</li><li>It's <b>unique mixture of barley and hops</b> delivers a full – never diluted – flavor that's just as tasty as regular beer</li><li>24 x 330 ml bottles </li></ul>
2562 <ul><li>4th STREET Natural Sweet Red is easy to drink, <b>fresh</b> and naturally sweet</li><li>Unashamedly uncomplicated, easy-drinking and versatile, 4th STREET is a wine inspired by a passion for friendship and sharing</li><li>Easy drinking low alcohol sweet red wine</li><li>Great wine as entry into the wine category</li><li>This is the perfect Rare Red Blend</li><li>The 4th Street Sweet Red wine has a fruity sweetness which comes from preserving fresh grape juice, allowing no fermentation</li><li>It combines its sophisticated taste perfectly with the playful fruity taste </li><li>If you’re all about the perfect combination of playful and edgy, then this is the wine for you</li></ul>
2563 <ul><li>4th STREET Natural Sweet Red is easy to drink, <b>fresh</b> and naturally sweet</li><li>Unashamedly uncomplicated, easy-drinking and versatile, 4th STREET is a wine inspired by a passion for friendship and sharing</li><li>Easy drinking low alcohol sweet red wine</li><li>Great wine as entry into the wine category</li><li>This is the perfect Rare Red Blend</li><li>The 4th Street Sweet Red wine has a fruity sweetness which comes from preserving fresh grape juice, allowing no fermentation</li><li>It combines its sophisticated taste perfectly with the playful fruity taste </li><li>If you’re all about the perfect combination of playful and edgy, then this is the wine for you</li></ul>
2564 <ul><li>The fruity sweetness comes from preserving fresh grape juice, allowing no fermentation</li><li>Careful blending in the cellar gives a wine low in alcohol while bursting with fruity freshness</li><li>This is the perfect Rare Red Blend</li><li>The 4th Street Sweet Red wine has a fruity sweetness which comes from preserving fresh grape juice, allowing no fermentation</li><li> It combines its sophisticated taste perfectly with the playful fruity taste</li><li> If you’re all about the perfect combination of playful and edgy, then this is the wine for you</li></ul>
2624 <ul><li>This velvety red is a true Cape legend, medium bodied with a tantalizing bouquet of red currant, almond, and cedar wood and vanilla</li><li>This blend of Cabernet Franc, Cabernet Sauvignon, Merlot, Shiraz and Petit Verdot offers a long spicy finish</li></ul>
2626 <ul><li>Allesverloren is a Fine Old Vintage Port </li><li>Excellent enjoyed on its own or served with cheese and desserts</li><li>The seven varietals from which this wine is made came from trellised vineyards, grown in Malmesbury shale and situated some 270m to 340m above sea level</li></ul> <p><br /></p>
2741 <ul><li>Alvi's Drift pinotage has been a speciality of the cellar since it was first bottled in 2006</li><li>The wine has a strong, medium dark colour with a garnet hue</li><li>The bouquet and palate are filled with juicy, ripe berry characters with mulberry and blackberry dominating</li><li>The tannin structure is well balanced with the oak and fruit</li><li>Subtle vanillin oak is integrated with hints of chocolate and dark cherries</li></ul>
2825 <ul><li><span style="color:rgb(0,0,0);">Cabernet is known for its distinctive dark fruit flavors, high <a href="https://www.wine-searcher.com/technical-wine-terms-q-t.lml#tannins" title="'Tannin' definition" target="_self" rel="noreferrer noopener">tannins</a>, good acidity, and full-bodied texture</span></li><li><span style="color:rgb(0,0,0);">It is often used to ameliorate lesser grape varieties with its strength</span></li></ul>
2842 <ul><li>Alvi's Drift full bodied merlot is a soft, juicy wine with a hint of tobacco characters on the nose and palate </li><li>A great value <b>merlot</b> from our wine estate</li><li>Signature Wine Bottle 750ml </li><li>The wine is a lovely blend of fruit, oak, and tannin</li><li>Full bodied for a merlot, yet soft and juicy with subtle</li></ul>
4395 <ul><li>The story behind the name Absolut Kurant is black kurant, a typical Swedish berry from which the flavor is taken</li><li>When launched in 1992 it was a tribute to the Swedish origin of Absolut Vodka</li><li>It's smooth and mellow, with a fruity black currant character and a hint of tartness</li></ul>
11788 999 DURBANVILLE HILLS WINE CHARDONNAY 1 x 750ML (1S)
11790 <p>999 SPIER WINE CHARDONNAY 1 x 750ML (BOTTLE)</p>
11802 <ul><li>The Cabernet Sauvignon Grape is <b>Delightfully Dark Red</b> and Delicious.</li><li>With its mature dark red colour the Alvi's Drift Cabernet Sauvignon is an excellent wine</li><li>Celebrated at culinary tables accompanying a mint infused roast lamb, a delicious Tagliatelle or a sizzling sirloin</li></ul>
11803 <ul><li><b>Star bright wine with tinges of lime green</b></li><li>Charming aromas of white peach, blossoms and citrus</li><li>Crisp acidity, balanced beautifully with the fruit that follow through on the palate, backed by a soft creamy texture that lingers long and finishes with a refreshing lime character</li></ul>
11804 <ul><li>The Alvi's Drift AD Chardonnay has a <b>lively pale lemon yellow with a hint of green</b></li><li>The nose is blend of cashew nuts, subtle peach and flinty, toasted oak</li><li>Very specific vinification techniques and the barrel maturation process have resulted in an integrated and elegant wine</li></ul>
12657 <p>ANDIAMO P\MIXERS BITTER ORANGE APERITIF 1 x 750ML (EA)</p>
12697 <p>ALVIS DRIFT SAUVIGNON BLANC 1 x 750ML (EA)</p>
12698 999 VERGELEGEN WINE MILL RACE RED 1 x 750ML (1S)
12711 <p>ALVIS DRIFT BRUT ROSE SPARKLING 1 x 750ML (EA)</p>