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, 
  cscart_product_descriptions.meta_keywords, 
  cscart_product_descriptions.meta_description, 
  cscart_product_descriptions.search_words, 
  cscart_product_descriptions.promo_text 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    92533, 92532, 93007, 98607, 92736, 92513, 
    92806, 92805, 92473, 92830, 92829, 
    92276, 92612, 92663, 92118, 98608, 
    92778, 92777, 92776, 92775
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00040

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_product_descriptions range PRIMARY,product_id PRIMARY 9 20 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
92118 FE328,Fatal Energy Records,Heppy
92276 IT065,Infused Traxx,DJ Darroo
92473 WAOD065,We Are One Digital,Ganar
92513 Scott Attrill, Beats N' Bass Part 4, Riot Recordings, Original Mix, Tech Dance, Featured Hard Dance New, Hard Dance, Toolbox Digital Download Beats N' Bass Part 4 (Original Mix) by Riot Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. RIOT191,Riot Recordings,Scott Attrill
92532 HDP001,Traffic Records,Aaron Olson,Scott Attrill
92533 HDP001,Traffic Records,Adrenaline Dept.,Venetica,Technikal
92612 DNZF941,DNZ Records,Zero Range
92663 DNZF940,DNZ Records,Silent Skies
92736 RTR003,Reignite The Rave,Ganar
92775 HS04,Hardest Soft,Freeboy
92776 HS04,Hardest Soft,Freeboy
92777 HS04,Hardest Soft,Freeboy
92778 HS04,Hardest Soft,Freeboy,LOUISE
92805 ARX003,Arkham Extreme,Professor Xavier,Paul Bartolome
92806 ARX003,Arkham Extreme,Professor Xavier,Paul Bartolome
92829 DNZ435,DNZ Records,Dj Oskar,Adelle,Nova Scotia
92830 DNZ435,DNZ Records,Dj Oskar,Adelle,Roky
93007 DNZF949,DNZ Records,Barry P
98607 blashear,brisk tempo,radiation recordings,hardtrance,hard dance,techtrance,trance,radiation,trance,hard trance,trance Another one of Argentina's heavy hitters Blashear joins the label with his killer track 'Brisk Tempo'. blashear,brisk tempo,radiation recordings,hardtrance,hard dance,techtrance,trance,radiation,trance,hard trance,trance
98608 mickey marr,roar,mickey crilly,radiation recordings,hardtrance,hard dance,techtrance,trance,radiation,trance,hard trance,trance Label boss Mickey Marr finally makes his debut on Radiation with this piledriver of a track 'ROAR'. mickey marr,roar,mickey crilly,radiation recordings,hardtrance,hard dance,techtrance,trance,radiation,trance,hard trance,trance