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 (
    62636, 62635, 62634, 62633, 62632, 62631, 
    62630, 62629, 62628, 62627, 62626, 
    62625, 62611, 62609, 62607, 62569, 
    62456, 61887, 60269, 62370, 62342, 
    62098, 62097, 61770, 61769, 61704, 
    60784, 60268, 62217, 61403, 61442, 
    62055, 61886, 61768, 60787, 60267, 
    62105, 61512, 62019, 61960
  ) 
  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 40 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
60267
60268
60269
60784
60787
61403 Hagane Shizuka, IP, Make It With Drums, Fatal Energy Records, Hagane Shizuka Hardbass Like It's '06 Remix, Tech Dance, Exclusive, Toolbox Digital Download Make It With Drums (Hagane Shizuka Hardbass Like It's '06 Remix) by Fatal Energy Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. FE095,Fatal Energy Records,IP,Hagane Shizuka
61442 DT081,Devious Trax,Dale West
61512 AAA146,Ahura Mazda Recordings NITRO,Burak Harsitlioglu
61704 DB015,Drop Bear Digital ,Mark Hard,Dan Dyson
61768
61769
61770
61886 hardhouse,steve,clack,sean,inside,out,premonitiondigital,toolbox,harddance hardhouse,steve,clack,sean,inside,out,premonitiondigital,toolbox,harddance
61887 hardhouse,markyp,harddance,premonitondigital,I.will.shut.that.shit.down hardhouse,markyp,harddance,premonitondigital,I.will.shut.that.shit.down
61960
62019 BK & TBF, Everything We Are, The Bounce Factory, Exclusive, Toolbox Digital Download Everything We Are by The Bounce Factory from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Everything we are , BK, TBF
62055
62097 Cheek341,Cheeky Tracks,Mikey
62098 Cheek341,Cheeky Tracks,Mikey
62105
62217
62342 Danny Harris, Changing, Jeli Jams, Exclusive, Toolbox Digital Up next we have a beast of a tune from the one and only Danny Harris. No stranger to big uplifting tracks that pack a punch. ‘Changing’ is powered by a brutal rolling bassline, big vocal and a recognisable hoover riff. This combination makes this track a James Price, Selina Ridgway, Danny Harris, Changing, Dave Owens, Jeli Jams
62370
62456 Insidious, Killawatt, Top Notch Digital, Hard House Insidious & Killawatt, Insidious, Killawatt
62569 Sean Inside Out, D-Fi, Mind Scatter, Solid State Digital, SSD025 Sean Inside Out & D-Fi - Mind Scatter Released on Solid State Digital Sean Inside Out, D-Fi, Mind Scatter, Solid State Digital, SSD025
62607 Art,Of,Trance,Madagascar,Remix,Reboot,Rework,Bootleg,Matt,Wade,Pez,Steve,Taylor,Mad,As,Cheeze,Neverland,Recordings The first of a string of new artists to feature on the label, Matt Wade & Pez have produced a fun packed reboot of this platypus classic which will be getting the Lost Boys remix treatment next year too Art,Of,Trance,Madagascar,Remix,Reboot,Rework,Bootleg,Matt,Wade,Pez,Steve,Taylor,Mad,As,Cheeze,Neverland,Recordings
62609 TMP092,Marc Lewis,Necessary Evil,Tempo Trax,Hard House Hard House TMP092,Marc Lewis,Necessary Evil,Tempo Trax,Hard House
62611
62625 Daley, JP & Jukesy, Nik Denton, What You Got Left, Toolbox Recordings, Nik Denton Twist Remix, Exclusive, Toolbox Digital Download What You Got Left (Nik Denton Twist Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62626 Hi Freak1c, Kris O'Rourke, Pulse Fiction, DisFUNKtional Disco, Toolbox Recordings, Pulse Fiction Disco At The Savoy Remix, Exclusive, Toolbox Digital Download DisFUNKtional Disco (Pulse Fiction Disco At The Savoy Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62627 Pocock, Pulse Fiction, You've Got This, Toolbox Recordings, Pulse Fiction Remix, Exclusive, Toolbox Digital Download You've Got This (Pulse Fiction Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62628 Nik Denton, Trauma, Fantastic, Toolbox Recordings, Nik Denton Remix, Exclusive, Toolbox Digital Download Fantastic (Nik Denton Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62629 Pulse Fiction, Electric Disco, Toolbox Recordings, Exclusive, Toolbox Digital Download Electric Disco by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62630 Nik Denton, Kamishake, Toolbox Recordings, Exclusive, Toolbox Digital Download Kamishake by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62631 Nik Denton, Robbie Muir, 94%, Toolbox Recordings, Nik Denton Remix, Exclusive, Toolbox Digital Download 94% (Nik Denton Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62632 Nik Denton, Paul King, Sucka Ma Foo, Toolbox Recordings, Exclusive, Toolbox Digital Download Sucka Ma Foo by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62633 DJ Pseudo, Nik Denton, Rodi Style, Pistol Packin', Toolbox Recordings, Nik Denton Retro Trade Remix, Exclusive, Toolbox Digital Download Pistol Packin' (Nik Denton Retro Trade Remix) by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62634 Nik Denton, Freak Right Out, Toolbox Recordings, Exclusive, Toolbox Digital Download Freak Right Out by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62635 Frank Farrell, Pulse Fiction, Mad Tarts On Acid, Toolbox Recordings, Exclusive, Toolbox Digital Download Mad Tarts On Acid by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
62636 Nik Denton, Fatal Abuse, Toolbox Recordings, Exclusive, Toolbox Digital Download Fatal Abuse by Toolbox Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.