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 (
    40629, 79914, 40775, 40774, 40621, 40620, 
    40616, 40948, 40187, 40186, 40185, 
    40779, 40778, 40231, 40174, 79928, 
    40167, 40166, 40165, 40531, 40773, 
    40772, 40157, 40156, 40152, 40151, 
    40150, 40069, 40111, 40110, 40857, 
    40106, 40102, 40101, 40099, 40098, 
    40097, 40096, 40088, 40087, 40081, 
    40092, 40007, 40006, 40005, 39997, 
    39994, 39982, 39980, 39977, 39976, 
    39975, 39974, 39973, 39972, 39971, 
    39970, 39969, 39968, 39967, 39966, 
    39962, 39950, 79918, 40105, 39991, 
    39960, 39923, 39916, 39907, 39906, 
    91051, 91050, 91049, 91048, 91047, 
    91046, 91045, 91044, 91043
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00134

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
39906 Dj Nau, Ruge, The One I Love, C58 Records, Rmx, Hardcore, Toolbox Digital Download The One I Love (Rmx) by C58 Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. C58018,C58 Records,Ruge,Dj Nau
39907 C58018,C58 Records,Ruge,Dj Nau
39916 UHD061,Universal Hardcore Digital,Ganah
39923 KO3, Starlit Oasis, Venom Drive, Original Mix, Featured Hardstyle, Hardcore, Toolbox Digital Download Starlit Oasis (Original Mix) by Venom Drive from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. VD009,Venom Drive,KO3
39950 DR028,Desk Records,Paris Makina Team
39960 Klubfiller, Re-Con, Freak, Klubbed Up, Original Mix, Hardstyle, Toolbox Digital Download Freak (Original Mix) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU029,Klubbed Up,Re-Con,Klubfiller
39962 C0R3Y, IYF, Ladies & Gentlemen, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Ladies & Gentlemen (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. UHD063,Universal Hardcore Digital,IYF,C0R3Y
39966 WNHB001,White Noize Hardcore,Darren G
39967 WNHB001,White Noize Hardcore,Darren G
39968 WNHB001,White Noize Hardcore,Darren G
39969 WNHB001,White Noize Hardcore,Darren G,Bridson
39970 WNHB001,White Noize Hardcore,Darren G,Bridson
39971 WNHB001,White Noize Hardcore,Darren G,Bridson
39972 WNHB001,White Noize Hardcore,Darren G,Bridson
39973 WNHB001,White Noize Hardcore,Darren G,Bridson,Allison
39974 WNHB001,White Noize Hardcore,Darren G,Bridson
39975 Darren G, Gemma B, Powerstomp Energy, White Noize Hardcore, Original Mix, Hardcore, Toolbox Digital Download Powerstomp Energy (Original Mix) by White Noize Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. WNHB001,White Noize Hardcore,Darren G,Gemma B
39976 WNHB001,White Noize Hardcore,Darren G,Dj Overdrive
39977 WNHB001,White Noize Hardcore,Darren G,Maxi Malone
39980 VD010,Venom Drive,JDM,Stephey
39982 WNH103,White Noize Hardcore,Nu-Vizion,Darren G,Dj Violate
39991 EMF055,Emfa Music,S3RL,Emi
39994 Darren Styles, Dougal, Gammer, Stay Young, Together We Rise, Original Mix, Hardcore, Toolbox Digital Download Stay Young (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. TWR2,Together We Rise,Darren Styles,Dougal,Gammer
39997 STI032,Stomp-Inc UK,Dj Spesh
40005 STI031,Stomp-Inc UK,Dj Spesh
40006 Reynolds, Tyl3r, Dive In, Futureworld Records, Original Mix, Hardcore, Toolbox Digital Download Dive In (Original Mix) by Futureworld Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NFWORLD043,Futureworld Records,Tyl3r,Reynolds
40007 Tyl3r, Club Shit, Futureworld Records, Original Mix, Hardcore, Toolbox Digital Download Club Shit (Original Mix) by Futureworld Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NFWORLD043,Futureworld Records,Tyl3R
40069 Clowny, Dirty Harry, Faithfulness, Premonition Digital, Hardcore, Toolbox Digital Download Faithfulness by Premonition Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. hardcore,premonitiondigital,dirtyharry,technikcore,htid
40081 IYF, ROXIE, You Nobody Else, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download You Nobody Else (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. UHD064,Universal Hardcore Digital,IYF,ROXIE
40087 Miss Special K, Come Together, Totally Ardcore Records, Original Mix, Hardcore, Toolbox Digital Download Come Together (Original Mix) by Totally Ardcore Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TA009,Totally Ardcore Records,Miss Special K
40088 J@m!e, Mind Blown, Totally Ardcore Records, Original Mix, Hardcore, Toolbox Digital Download Mind Blown (Original Mix) by Totally Ardcore Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TA009,Totally Ardcore Records,J@m!e
40092 UNITE034,Unite Records,Zatox,Art Of Fighters
40096 MRV199,Megarave Records,Distortion,Dione
40097 MRV199,Megarave Records,Distortion
40098 MRV199,Megarave Records,Rotterdam Terror Corps,Dione
40099 MRV199,Megarave Records,Rotterdam Terror Corps,Roughsketch
40101 VD011,Venom Drive,JDM
40102 STI035,Stomp-Inc UK,Area 51
40105 Klubfiller, Sc@r, Stu Hughes, Last Forever, Scarred Digital, Sc@r & Klubfiller Remix, Hardcore, Toolbox Digital Download Last Forever (Sc@r & Klubfiller Remix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD070,Scarred Digital,Klubfiller,Stu Hughes,Sc@r
40106 Bananaman, Evolve, Gisbo, Lisa Abbott, Living The Dream, Jump 4 Joy, Bananaman & Gisbo Remix, Hardcore, Toolbox Digital Download Living The Dream (Bananaman & Gisbo Remix) by Jump 4 Joy from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JJ014,Jump 4 Joy,Evolve,Lisa Abbott,Bananaman,Gisbo
40110 STI036,Stomp-Inc UK,Area 51
40111 STI033,Stomp-Inc UK,Dj Spesh
40150 RS038,Rebirth Society,Mental Crush
40151 RS038,Rebirth Society,Mental Crush
40152 RS038,Rebirth Society,Mental Crush
40156 KU030,Klubbed Up,DJ Kambel,TJ Blitz
40157 Chris Unknown, DJ Kambel, No More Joking 2015, Klubbed Up, Chris Unknown Remix, Hardcore, Toolbox Digital Download No More Joking 2015 (Chris Unknown Remix) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU030,Klubbed Up,DJ Kambel,Chris Unknown
40165 DJ Humid, Trek, Scarred Digital, Original Mix, Hardcore, Toolbox Digital Download Trek (Original Mix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD071,Scarred Digital,DJ Humid
40166 Dj Metix, Hard Times, C58 Records, Original Mix, Hardcore, Toolbox Digital Download Hard Times (Original Mix) by C58 Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. C58019,C58 Records,Dj Metix
40167 C58019,C58 Records,Dj Metix
40174 C0R3Y, IYF, ROXIE, Checkmate, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Checkmate (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. UHD065,Universal Hardcore Digital,IYF,C0R3Y,Roxie
40185 VD012,Venom Drive,X-A7T,Camo,Nate Monoxide
40186 VD012,Venom Drive,X-A7T,Hazelnut
40187 Darren G, Nu-Vizion, So Alive, White Noize Hardcore, Darren G Remix, Hardcore, Toolbox Digital Download So Alive (Darren G Remix) by White Noize Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. WNH104,White Noize Hardcore,Nu-Vizion,Darren G
40231 Javi Tracker, Destiny, Desk Records, Original Mix, Hardcore, Toolbox Digital Download Destiny (Original Mix) by Desk Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DR029,Desk Records,Javi Tracker
40531 DJ025,DJs at Work,Julio Posadas
40616 Dougal, Gammer, The World, Together We Rise, Original Mix, Hardcore, Toolbox Digital Download The World (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. TWR3,Together We Rise,Dougal,Gammer
40620 STI034,Stomp-Inc UK,Spesh,Area 51
40621 Liqo, M-Project, Drop The Beat, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download Drop The Beat (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR069,Contagious Records,M-Project,Liqo
40629 Haze, Let Me Hear You, JTS Recordings, Original Mix, Hardcore, Toolbox Digital Download Let Me Hear You (Original Mix) by JTS Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. JTS042,JTS Recordings,Haze
40772 Scott Brown, Eternal Soul, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Eternal Soul (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev46,Evolution Records,Scott Brown
40773 Ev46,Evolution Records,Scott Brown
40774 QTEX, Viroid, Evolution Records, Original Mix, Featured Hardcore, Hardcore, Toolbox Digital Download Viroid (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev44,Evolution Records,QTEX
40775 QTEX, Genesis, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Genesis (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev44,Evolution Records,QTEX
40778 Ev42,Evolution Records,Scott Brown
40779 Scott Brown, Turn Around, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Turn Around (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev42,Evolution Records,Scott Brown
40857 Just Jack, Sing To Me, The Future Of Hardcore, Original Mix, Featured Hardcore, Hardcore, Toolbox Digital Download Sing To Me (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. TFOH0084,The Future Of Hardcore,Just Jack
40948 HSR038,Hard Soundz Recordings,DJ Jay G
79914 JH150,Justice Hardcore,Project Shadow
79918 JH148,Justice Hardcore,IYF,Nobody,Burtside
79928 JH149,Justice Hardcore,Nobody,Ciccone,Pinnacle
91043 KCRCD007,KyokudoCore Records,13.c.Gilbert
91044 KCRCD007,KyokudoCore Records,HENTAiCORE
91045 KCRCD007,KyokudoCore Records,Kether Inside
91046 KCRCD007,KyokudoCore Records,Coakira
91047 KCRCD007,KyokudoCore Records,FRN-G
91048 KCRCD007,KyokudoCore Records,Kurwastyle Project,Furere Lycanthrope
91049 KCRCD007,KyokudoCore Records,RYUWAVE
91050 KCRCD007,KyokudoCore Records,Ayane Fukumi
91051 KCRCD007,KyokudoCore Records,Loffciamcore