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 (
    41027, 41026, 41025, 41024, 41023, 41022, 
    41021, 41020, 41019, 41018, 40998, 
    40954, 40896, 40895, 40894, 40888, 
    41357, 41356, 41355, 41354, 41353, 
    41352, 41351, 41350, 41349, 41348, 
    41347, 41346, 41345, 41344, 41343, 
    41342, 41341, 41340, 41338, 41337, 
    41336, 41335, 41334, 41333, 41332, 
    41331, 41330, 41329, 41328, 41327, 
    41326, 41325, 41324, 41140, 40854, 
    40853, 41004, 41003, 41002, 40946, 
    40842, 40841, 40837, 40836, 40835, 
    40834, 40833, 40872, 40866, 41147, 
    40784, 40783, 40777, 40776, 40798, 
    40797, 40686, 40671, 79898, 40781, 
    40780, 40642, 41150, 40634
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00118

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
40634 Jordi K-Stana, V-nax, Climax, NOx Records, Original Mix, Hardcore, Toolbox Digital Download Climax (Original Mix) by NOx Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NOxV001,NOx Records,Jordi K-Stana,V-Nax
40642 Ganah, Trouble In The Club, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Trouble In The Club (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. UHD066,Universal Hardcore Digital,Ganah
40671 Alex BassJunkie, Headbanger, Venom Drive, Re-Work, Hardcore, Toolbox Digital Download Headbanger (Re-Work) by Venom Drive from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. VD013,Venom Drive,Alex BassJunkie
40686 JTS, Scott Brown, I'll Be Yours, Evolution Records, JTS Remix, Hardcore, Toolbox Digital Download I'll Be Yours (JTS Remix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev113,Evolution Records,Scott Brown,JTS
40776 J-Mac, Klubfiller, Nuton, I Love You Baby, Klubbed Up, Original Mix, Hardstyle, Toolbox Digital Download I Love You Baby (Original Mix) by Klubbed Up from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KU031,Klubbed Up,Klubfiller,J-Mac,Nuton
40777 Riko, The Phat Boyz, Are You Ready, Contagious Records, Original Mix, Hardcore, Toolbox Digital Download Are You Ready (Original Mix) by Contagious Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. CR071,Contagious Records,Riko,The Phat Boyz
40780 Scott Brown, Love Me Too, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Love Me Too (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev47,Evolution Records,Scott Brown
40781 Scott Brown, Sensation, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Sensation (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev47,Evolution Records,Scott Brown
40783 Bass-x, Put Your Hands Up, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Put Your Hands Up (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev48,Evolution Records,Bass-x
40784 Ev48,Evolution Records,Bass-x
40797 Interstate, Beloved, Evolution Records, Original Mix, Featured Hardcore, Hardcore, Toolbox Digital Download Beloved (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev49,Evolution Records,Interstate
40798 Interstate, Get Up On It, Evolution Records, Original Mix, Featured Hardcore, Hardcore, Toolbox Digital Download Get Up On It (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev49,Evolution Records,Interstate
40833 Ev114,Evolution Records,Euphony,Scott Brown
40834 Euphony, Scott Brown, Space Invader, Evolution Records, Scott Brown (Original 1999 Remix), Hardcore, Toolbox Digital Download Space Invader (Scott Brown (Original 1999 Remix)) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev114,Evolution Records,Euphony,Scott Brown
40835 Ev114,Evolution Records,Euphony,Quest
40836 Ev114,Evolution Records,Euphony,Al Storm,B-Man
40837 Ev114,Evolution Records,Euphony,Warped Science
40841 Ev54,Evolution Records,Q-Tex
40842 Q-Tex, The First Parable, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download The First Parable (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev54,Evolution Records,Q-Tex
40853 Scott Brown, Johnny, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Johnny (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev52,Evolution Records,Scott Brown
40854 Ev52,Evolution Records,Scott Brown
40866 EMF057,Emfa Music,S3RL,Krystal
40872 Gemma MacLeod, Reflux, Vibrance, End Of The Day, Scarred Digital, Original Mix, Hardcore, Toolbox Digital Download End Of The Day (Original Mix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD072,Scarred Digital,Reflux,Vibrance,Gemma Macleod
40888 Atmozfears, Code Black, Darren Styles, Accelerate, Together We Rise, Darren Styles Edit, Hardcore, Toolbox Digital Download Accelerate (Darren Styles Edit) by Together We Rise from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. TWR4,Together We Rise,Code Black,Atmozfears,Darren Styles
40894 STI037,Stomp-Inc UK,DJ Spesh
40895 Interstate, Move Your Body, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Move Your Body (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev51,Evolution Records,Interstate
40896 Interstate, Rock Da House, Evolution Records, Original Mix, Hardcore, Toolbox Digital Download Rock Da House (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev51,Evolution Records,Interstate
40946 Javiolo, Move It, Desk Records, Original Mix, Hardcore, Toolbox Digital Download Move It (Original Mix) by Desk Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. DR030,Desk Records,Javiolo
40954 IYF, ROXIE, Stu Woods, Higher Spirit, Universal Hardcore Digital, Original Mix, Hardcore, Toolbox Digital Download Higher Spirit (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. UHD068,Universal Hardcore Digital,IYF,Stu Woods,Roxie
40998 Bananaman, Gisbo, JHAL, Lisa Abbott, Life We Share, Jump 4 Joy, Bananaman & Gisbo Remix, Hardcore, Toolbox Digital Download Life We Share (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. JJ015,Jump 4 Joy,JHAL,Lisa Abbott,Bananaman,Gisbo
41002 MOK157,Mokum Records,DJ Macho
41003 MOK157,Mokum Records,The Chronic
41004 MOK157,Mokum Records,Raoul
41018 RSA001,Rebirth Society,Mental Crush
41019 RSA001,Rebirth Society,Mental Crush
41020 RSA001,Rebirth Society,Mental Crush
41021 RSA001,Rebirth Society,Mental Crush
41022 RSA001,Rebirth Society,Mental Crush
41023 RSA001,Rebirth Society,Mental Crush
41024 RSA001,Rebirth Society,Mental Crush
41025 RSA001,Rebirth Society,Mental Crush
41026 RSA001,Rebirth Society,Mental Crush
41027 RSA001,Rebirth Society,Mental Crush
41140 B-Man, Gisbo, Jodie, Blue Eyes, 24/7 Hardcore, Original Mix, Hardcore, Toolbox Digital Download Blue Eyes (Original Mix) by 24/7 Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. 247HC099,24/7 Hardcore,B-Man,Gisbo,Jodie
41147 Jakka-B, Strait Jackket, The Future Of Hardcore, Original Mix, Hardcore, Toolbox Digital Download Strait Jackket (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. TFOH0086,The Future Of Hardcore,Jakka-B
41150 Snipes & Ganah, Kicking The Flow, The Future Of Hardcore, Original Mix, Hardcore, Toolbox Digital Download Kicking The Flow (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. TFOH0085,The Future Of Hardcore,Snipes & Ganah
41324 RLDBUNDL076,Relentless Digital!,A.B
41325 RLDBUNDL076,Relentless Digital!,Clowny
41326 RLDBUNDL076,Relentless Digital!,Clowny,X-Fir3
41327 RLDBUNDL076,Relentless Digital!,Clowny
41328 RLDBUNDL076,Relentless Digital!,Clowny,Reminsce,Nelza
41329 RLDBUNDL076,Relentless Digital!,Evolutionize
41330 RLDBUNDL076,Relentless Digital!,Evolutionize
41331 RLDBUNDL076,Relentless Digital!,Evolutionize
41332 RLDBUNDL076,Relentless Digital!,Evolutionize
41333 RLDBUNDL076,Relentless Digital!,Hommarju
41334 RLDBUNDL076,Relentless Digital!,Hommarju
41335 RLDBUNDL076,Relentless Digital!,Hommarju
41336 RLDBUNDL076,Relentless Digital!,Hommarju,MK
41337 RLDBUNDL076,Relentless Digital!,Le Dos On
41338 RLDBUNDL076,Relentless Digital!,Le Dos On
41340 RLDBUNDL076,Relentless Digital!,Le Dos On
41341 RLDBUNDL076,Relentless Digital!,Le Dos On
41342 RLDBUNDL076,Relentless Digital!,Liberty,Nomic
41343 RLDBUNDL076,Relentless Digital!,Ranzor
41344 RLDBUNDL076,Relentless Digital!,Ranzor
41345 RLDBUNDL076,Relentless Digital!,Ranzor
41346 RLDBUNDL076,Relentless Digital!,Ranzor
41347 RLDBUNDL076,Relentless Digital!,S3RL,Nix
41348 RLDBUNDL076,Relentless Digital!,S3RL,Sara
41349 RLDBUNDL076,Relentless Digital!,X-Fir3
41350 RLDBUNDL076,Relentless Digital!,X-Fir3
41351 RLDBUNDL076,Relentless Digital!,S3RL,X-Fir3
41352 RLDBUNDL076,Relentless Digital!,X-FIR3,Sensation
41353 RLDBUNDL076,Relentless Digital!,Rob Marro,The Entranced
41354 RLDBUNDL076,Relentless Digital!,Rob Marro,The Entranced,Clowny
41355 RLDBUNDL076,Relentless Digital!,S3RL,X-Fir3
41356 RLDBUNDL076,Relentless Digital!,X-Fir3
41357 RLDBUNDL076,Relentless Digital!,X-Fir3
79898 JH151,Justice Hardcore,Ganar