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 (
    99275, 99272, 99262, 99261, 99258, 99217, 
    99132, 99129, 99124, 98903, 98630, 
    98626, 98625, 98566, 97667, 99274, 
    89234, 99131, 98519, 99123
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00063

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
89234
97667 Gary O'Connor, Escargot, Team Sly, Digital Snail Gary O'Connor, Escargot, Team Sly, Digital Snail
98519 BTN019,Bring The Noise Recordings,Dan Carter
98566 ED014,Epidemic Digital,D-Fi,DJ Miss Vixen
98625
98626
98630 Cupra, Fire in the hole, slingshot Cupra, Fire in the hole, slingshot
98903 Mischief,Duo,Psycho Mischief Duo - Pyscho Mischief, Duo, Psycho
99123 TMP185,Defective Audio,Only The Gods See Everything,Tempo Trax,Hard House Hard House TMP185,Defective Audio,Only The Gods See Everything,Tempo Trax,Hard House
99124 TMP186,Matt Clarkson,J Lowe,Don't Stop The Dance,Tempo Trax,Hard House Hard House TMP186,Matt Clarkson,J Lowe,Don't Stop The Dance,Tempo Trax,Hard House
99129 Global,Awakening,Records Global,Awakening,Records
99131
99132 K-Zone, Delinquents, The Guvnah, Hardhouse, Aaron James, Seanie Jackson, Adam Butler, K-Zone, Delinquents, The Guvnah, Hardhouse, Aaron James, Seanie Jackson, Adam Butler
99217
99258 Revenge DJ Serenity Energy Source Productions Hard House Revenge DJ Serenity Energy Source Productions Hard House Revenge DJ Serenity Energy Source Productions Hard House
99261 reaper,the,stand,pitch,drift reaper,the,stand,pitch,drift reaper,the,stand,pitch,drift
99262 stu,angus,mind,hunter,pitch,drift stu,angus,mind,hunter,pitch,drift stu,angus,mind,hunter,pitch,drift
99272 Tara n, djone7tout, full circle productions
99274 RPR197, Weazal, Phatt Beats, Dave Owens, rumble in the jungle, darkness, Raw Power, hard house, filth, hoovers, NRG Getting very close to the 200th release now and I have been permission to re-release this beast as it was no longer available to buy. If you didn't grab this the first time around, make sure you don't miss out now! This track has one hell of a bassline, a RPR197, Weazal, Phatt Beats, Dave Owens, rumble in the jungle, darkness, Raw Power, hard house, filth, hoovers, NRG
99275