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 (
    48473, 48713, 48706, 48297, 48920, 48671, 
    48670, 48302, 48276, 48275, 48238, 
    48270, 48271, 48266, 48265, 48264, 
    48263, 48246, 48277, 48247, 48259, 
    48258, 48257, 48256, 48255, 48248, 
    48237, 48236, 48233, 48201, 48103, 
    48102, 48267, 48047, 48192, 48120, 
    48101, 48100, 48099, 48097, 47985, 
    47984, 48078, 48046, 48410, 48409, 
    48408, 48407, 48406, 48405, 48404, 
    48403, 48402, 48401, 48400, 48399, 
    48398, 48397, 48396, 48395, 48394, 
    48393, 48392, 48391, 48390, 48389, 
    48388, 48387, 48386, 48385, 48384, 
    48383, 48382, 48381, 48380, 48379, 
    48378, 48377, 48376, 48375
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00088

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 80 Using where

Result

product_id short_description full_description meta_keywords meta_description search_words promo_text
47984 STI063,Stomp-Inc UK,Area51
47985 Dougal, Gammer, Pigface, Together We Rise, Dougal & Gammer Edit, Hard Dance, Toolbox Digital Download Pigface (Dougal & Gammer Edit) by Together We Rise from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TWR22,Together We Rise,Gammer,Dougal
48046 Maxi Malone, The Gold Saucer, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download The Gold Saucer (Original Mix) by Universal Hardcore Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UHD093,Universal Hardcore Digital,Maxi Malone
48047 STI064,Stomp-Inc UK,Area 51
48078 DR057,Desk Records,DJ K-Bert
48097 JTS, Scott Brown, Never Stop, OneSeventy, Original Mix, Hard Dance, Toolbox Digital Download Never Stop (Original Mix) by OneSeventy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. ONESEVENTY2,OneSeventy,Scott Brown,JTS
48099 FINRG004,FINRG Recordings,Substanced
48100 FINRG004,FINRG Recordings,Substanced
48101 FINRG004,FINRG Recordings,Substanced
48102 Michael Scout, Mind Body Soul, Futureworld Records, Original Mix, Hard Dance, Toolbox Digital Download Mind Body Soul (Original Mix) by Futureworld Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NFWORLD054,Futureworld Records,Michael Scout
48103 Area51, Wanna Play, Stomp-Inc UK, Original Mix, Hardcore, Toolbox Digital Download Wanna Play (Original Mix) by Stomp-Inc UK from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STI065,Stomp-Inc UK,Area51
48120 Jay G, This Way I Get Down, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download This Way I Get Down (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR0113,Contagious Records,Jay G
48192 Doug Horizon, Zoe Van West, Reach For The Sky, Banginbeats Digital, Original Mix, Hardcore, Toolbox Digital Download Reach For The Sky (Original Mix) by Banginbeats Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BBD028,Banginbeats Digital,Doug Horizon,Zoe Van West
48201 GSP066,GSP,Gav G-Style
48233 STI067,Stomp-Inc UK,New Core Order Collective
48236 GSP065,GSP,Gav G-Style
48237 EXE066,Executive Records,Jamie Dudlee
48238 Darren Styles, It's Like That, Together We Rise, Original Mix, Hard Dance, Toolbox Digital Download It's Like That (Original Mix) by Together We Rise from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TWR23,Together We Rise,Darren Styles
48246 Core-Key, Deep Inside, Desk Records, Original Mix, Hardcore, Toolbox Digital Download Deep Inside (Original Mix) by Desk Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DR058,Desk Records,Core-Key
48247 DJ Strider, Mob, Madagascar, No Retreat, No Surrender Records, Original Mix, Hardcore, Toolbox Digital Download Madagascar (Original Mix) by No Retreat, No Surrender Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NRNS016,No Retreat, No Surrender Records,Mob,DJ Strider
48248 Midas, Transcend, Evolution Of Fire, Stamina Slam Series, Original Mix, Freeform, Hardcore, Toolbox Digital Download Evolution Of Fire (Original Mix) by Stamina Slam Series from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STMSLM017,Stamina Slam Series,Transcend,Midas
48255 SPECIAL004,Rebirth Society,Mental Crush,Buchecha
48256 SPECIAL004,Rebirth Society,Mental Crush
48257 SPECIAL004,Rebirth Society,Mental Crush,O.B.I.
48258 SPECIAL004,Rebirth Society,Mental Crush,Dominik Stuppy
48259 SPECIAL004,Rebirth Society,Mental Crush
48263 MOK167,Mokum Records,Peckerhead
48264 MOK167,Mokum Records,Peckerhead
48265 MOK167,Mokum Records,Peckerhead
48266 MOK167,Mokum Records,Peckerhead
48267 Que & Destroy, Stephanie Kay, Take What's Mine, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Take What's Mine (Original Mix) by Universal Hardcore Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UHD094,Universal Hardcore Digital,Que & Destroy,Stephanie Kay
48270 Clsm, DJ Dreem, What You Want, Out Of This World Records, Original Mix, Hardcore, Toolbox Digital Download What You Want (Original Mix) by Out Of This World Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. OOTW004,Out Of This World Records,DJ Dreem,CLSM
48271 Gav G-Style, SomethingsWrong, GSP, Original Hardcore Mix, Hardcore, Toolbox Digital Download SomethingsWrong (Original Hardcore Mix) by GSP from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. GSP067,GSP,Gav G-Style
48275 A.B, Miami, Stamina Records, Original Mix, Hardcore, Toolbox Digital Download Miami (Original Mix) by Stamina Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. STM030,Stamina Records,A.B
48276 STM030,Stamina Records,A.B
48277 Dj Metix, Urania, C58 Records, Original Mix, Hardcore, Toolbox Digital Download Urania (Original Mix) by C58 Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. C58028,C58 Records,DJ Metix
48297 D-Lyte, Jedi, Stormtrooper, Sy & Unknown, Keep It Locked, Jedi Recordings, Sy & Unknown Remix, Old Skool, Hardcore, Toolbox Digital Download Keep It Locked (Sy & Unknown Remix) by Jedi Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JEDI2,Jedi Recordings,Jedi,Stormtrooper,D-Lyte,Sy & Unknown
48302 Maxi Malone, Freedom, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Freedom (Original Mix) by Universal Hardcore Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UHD091,Universal Hardcore Digital,Maxi Malone
48375 TFOHBP3,The Future Of Hardcore,Gregor Le Dahl,Allison Gray
48376 TFOHBP3,The Future Of Hardcore,J-Skitz,Zoe Van West
48377 TFOHBP3,The Future Of Hardcore,Jakka-B
48378 TFOHBP3,The Future Of Hardcore,Jakka-B
48379 TFOHBP3,The Future Of Hardcore,Jakka-B,Infexious
48380 TFOHBP3,The Future Of Hardcore,Jekyll,Skoda
48381 Burnout, Joey Riot, U Got Da Funk, The Future Of Hardcore, Original Mix, Hardcore, Toolbox Digital Download U Got Da Funk (Original Mix) by The Future Of Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TFOHBP3,The Future Of Hardcore,Joey Riot,Burnout
48382 TFOHBP3,The Future Of Hardcore,Just Jack,Kane
48383 TFOHBP3,The Future Of Hardcore,Mickey Rush
48384 TFOHBP3,The Future Of Hardcore,N-Sane
48385 TFOHBP3,The Future Of Hardcore,N-Sane
48386 TFOHBP3,The Future Of Hardcore,N-Sane,M-Style
48387 TFOHBP3,The Future Of Hardcore,N-Sane,Scotty D,Bridson
48388 TFOHBP3,The Future Of Hardcore,Offside
48389 TFOHBP3,The Future Of Hardcore,Offside,Technical Difficulties
48390 TFOHBP3,The Future Of Hardcore,Outforce,Genic
48391 TFOHBP3,The Future Of Hardcore,S3RL,Mixie Moon,Mc Offside
48392 TFOHBP3,The Future Of Hardcore,SAS
48393 TFOHBP3,The Future Of Hardcore,Scotty D
48394 TFOHBP3,The Future Of Hardcore,Shock
48395 TFOHBP3,The Future Of Hardcore,Shock
48396 TFOHBP3,The Future Of Hardcore,Shock
48397 TFOHBP3,The Future Of Hardcore,Skindogg
48398 TFOHBP3,The Future Of Hardcore,Snipes & Ganah
48399 TFOHBP3,The Future Of Hardcore,Snipes,Murf
48400 MC Offside, Technical Difficulties, On The Run, The Future Of Hardcore, Original Mix, Hardcore, Toolbox Digital Download On The Run (Original Mix) by The Future Of Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TFOHBP3,The Future Of Hardcore,Technical Difficulties,Mc Offside
48401 TFOHBP3,The Future Of Hardcore,Technikore,Mc Static,Gregor Le Dahl
48402 TFOHBP3,The Future Of Hardcore,Wilson & Mizel
48403 TFOHBP3,The Future Of Hardcore,Titancube
48404 TFOHBP3,The Future Of Hardcore,Pex
48405 Kurt, Mike Ahmet, Shot Thru Da Speaker, The Future Of Hardcore, Original Mix, Hardcore, Toolbox Digital Download Shot Thru Da Speaker (Original Mix) by The Future Of Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TFOHBP3,The Future Of Hardcore,Kurt,Mike Ahmet
48406 TFOHBP3,The Future Of Hardcore,Technical Difficulties
48407 TFOHBP3,The Future Of Hardcore,S3rl,IYF,Hyperforce
48408 TFOHBP3,The Future Of Hardcore,Alex Bassjunkie,Richie
48409 TFOHBP3,The Future Of Hardcore,DJ Overflow
48410 TFOHBP3,The Future Of Hardcore,Burnout
48473 Jonny el, Roll The Drums, Futureworld Records, Original Mix, Hardcore, Toolbox Digital Download Roll The Drums (Original Mix) by Futureworld Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NFWORLD055,Futureworld Records,Jonny EL
48670 SWG0011,SWG Music,Josue Reyes
48671 SWG0011,SWG Music,Josue Reyes,DjPablo
48706 Hyperforce, Joey Riot, Newbie, Tom Revolution, Do You Remember, Wonky Donkey, Joey Riot & Tom Revolution 2016 Powerstomp Remix, Hardcore, Toolbox Digital Download Do You Remember (Joey Riot & Tom Revolution 2016 Powerstomp Remix) by Wonky Donkey from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DONKEY0010,Wonky Donkey,Hyperforce,Newbie,Joey Riot,Tom Revolution
48713 DONKEY0009,Wonky Donkey,Cruze,Tricky Rich
48920 Overdrive, I Wanna Get Up, The Future Of Hardcore, Original Mix, Hardcore, Toolbox Digital Download I Wanna Get Up (Original Mix) by The Future Of Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TFOH100,The Future Of Hardcore,Overdrive