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 (
    98472, 98471, 98470, 98469, 98468, 98467, 
    98430, 98392, 98377, 97901, 97817, 
    97108, 92932, 92931, 98391, 98386, 
    92930, 98380, 98379, 98378
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00043

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
92930 Joe Bloggs, Nebulizer, Vicious Circle, Exclusive, Toolbox Digital Download Nebulizer by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
92931
92932
97108 Carl Pearce, Cheryl Pearce, Frantic Digital, Hard Trance, The Universe Carl Pearce, Cheryl Pearce, Frantic Digital, Hard Trance, The Universe
97817 PMD043,Pumped,Joe Longbottom
97901 UTHHD049,Ultratech,Tara N
98377
98378 pat,glenny,haus,musik,pitch,drift pat,glenny,haus,musik,pitch,drift pat,glenny,haus,musik,pitch,drift
98379 Shoguns, Burning Blade, Tara N Shoguns, Burning Blade, Tara N
98380 sam,filth,bang,hard.house sam,filth,bang,hard.house
98386 Petr edwards, Full circle productions, Peter Edwards,Full circle productions
98391
98392 Bizarre Q Global Awakening Records,Bizarre Q,See Me In The Club
98430 Kaki Raphael, 20year old scorcher, Kaki Trax Kaki Raphael, 20year old scorcher, Kaki Trax
98467 ross,homson,terrbang,hard,house,toolboxdigital,piff,paff,poff ross,homson,terrbang,hard,house,toolboxdigital,piff,paff,poff
98468 ross,homson,terrbang,hard,house,toolboxdigital,Cream,Doughnut ross,homson,terrbang,hard,house,toolboxdigital,Cream,Doughnut
98469 ross,homson,terrbang,hard,house,toolboxdigital,got,the,flow ross,homson,terrbang,hard,house,toolboxdigital,got,the,flow
98470 ross,homson,terrbang,hard,house,toolboxdigital,galvez,groove ross,homson,terrbang,hard,house,toolboxdigital,galvez,groove
98471 ross,homson,terrbang,hard,house,toolboxdigital,Clusterfunk ross,homson,terrbang,hard,house,toolboxdigital,Clusterfunk
98472 ross,homson,terrbang,hard,house,toolboxdigital,gold,leaf ross,homson,terrbang,hard,house,toolboxdigital,gold,leaf