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 (
    51830, 51829, 59337, 52214, 51828, 51816, 
    51812, 51811, 51786, 51785, 51813, 
    51802, 51801, 51800, 51799, 51798, 
    51797, 51796, 51795, 51794, 51793, 
    51792, 51791, 51790, 51789, 51788, 
    51753, 51752, 51751, 51750, 51782, 
    51735, 91670, 91669, 91668, 51653, 
    51646, 51638, 51637, 51636, 51635, 
    111382, 51609, 51605, 51587, 51581, 
    51580, 51666, 51665, 51664, 51663, 
    51662, 51557, 51555, 51534, 51533, 
    51532, 51531, 51530, 51529, 51520, 
    51437, 51694, 51430, 51425, 51338, 
    51337, 51319, 51768, 51418, 51287, 
    51198, 51127, 51126, 51098, 51097, 
    51096, 51095, 51094, 51093
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00106

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
51093 Nuton, Way Back Home, Klubbed Up Collections, Original Mix, Hard Dance, Toolbox Digital Download Way Back Home (Original Mix) by Klubbed Up Collections from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KUCA11,Klubbed Up Collections,Nuton
51094 Chris Unknown, Klubfiller, Falling, Klubbed Up Collections, Original Mix, Hard Dance, Toolbox Digital Download Falling (Original Mix) by Klubbed Up Collections from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KUCA11,Klubbed Up Collections,Klubfiller,Chris Unknown
51095 Re-Con, Remembrance, Klubbed Up Collections, Original Mix, Hard Dance, Toolbox Digital Download Remembrance (Original Mix) by Klubbed Up Collections from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KUCA11,Klubbed Up Collections,Re-Con
51096 Demand, Gammer, Klubfiller, Mandy Edge, Re-Con, I'm Sorry, Klubbed Up Collections, Gammer & Klubfiller Remix, Hard Dance, Toolbox Digital Download I'm Sorry (Gammer & Klubfiller Remix) by Klubbed Up Collections from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. KUCA11,Klubbed Up Collections,Re-Con,Demand,Mandy Edge,Gammer,Klubfiller
51097 KUCA11,Klubbed Up Collections,J-Mac,Tom Hayward
51098 KUCA11,Klubbed Up Collections,Klubfiller
51126 Dowster, Vagabond, Keeping It Rocking, Candy Crush Music, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Keeping It Rocking (Original Mix) by Candy Crush Music from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. candy1186,Candy Crush Music,Dowster,Vagabond
51127 Eufeion, Gemma MacLeod, Catch My Fall, Ninja Hardcore, 2016 Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Catch My Fall (2016 Mix) by Ninja Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NINJAHC003,Ninja Hardcore,Eufeion,Gemma Macleod
51198 Hotchkiss, Mi'A, Scott Brown, Give Me Fire, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Give Me Fire (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev149,Evolution Records,Hotchkiss,Scott Brown,Mi'a
51287 NOTV029,Notorious Vinyl,Skinny,Marc Smith,Little Fella
51319 candy1187,Candy Crush Music,Dowster,Vagabond,MC Wotsee
51337 DJ038,DJs at Work,Migue
51338 DJ038,DJs at Work,Migue
51418 TFOM004,The Future Of Makina,Distorter
51425 JEDI12A,Jedi Recordings,DJ Jedi
51430 Bass-x, Scott Brown, One 2 Three, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download One 2 Three (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev150,Evolution Records,Scott Brown,Bass-X
51437 Burnout, Konekshon, Inside, Ballistik Hardcore, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Inside (Original Mix) by Ballistik Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BH043,Ballistik Hardcore,Burnout,Konekshon
51520 Dowster, Vagabond, The Spectre, Candy Crush Music, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download The Spectre (Original Mix) by Candy Crush Music from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. candy1188,Candy Crush Music,Dowster,Vagabond
51529 CR0124,Contagious Records,Riko,$kyline
51530 PCR038,Peacock Records,Mr. Ivex
51531 PCR038,Peacock Records,Mr. Ivex,Cyclon,Dr. Peacock
51532 DJ039,DJs at Work,VinylDJs,DJ Idroix
51533 PCR037,Peacock Records,Dr. Peacock,Mr. Ivex
51534 PCR037,Peacock Records,Mr. Ivex
51555 Al Storm, M-Project, Scott Brown, Run To Me, Evolution Records, M-Project Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download Run To Me (M-Project Remix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev151,Evolution Records,Scott Brown,Al Storm,M-Project
51557 CR0125,Contagious Records,Riko,Evo
51580 TA024,Totally Ardcore Records,J.K.O
51581 TA024,Totally Ardcore Records,J.K.O
51587 CR0126,Contagious Records,Riko,Shagg-E
51605 BFR0816,Bassface Recordings,ViolonC
51609 DJ040,DJs at Work,Yozue
51635 Digital20,Cenobite Records,M-Project,Steve Heller
51636 Digital20,Cenobite Records,M-Project,Steve Heller
51637 Digital20,Cenobite Records,M-Project,Steve Heller,Damian
51638 Scott Brown, Into The Blue, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Into The Blue (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev152,Evolution Records,Scott Brown
51646 BBD032,Banginbeats Digital,CJR,Mc Oddball
51653 NOTV030,Notorious Vinyl,Marc Smith,Joey Riot
51662 MOK171,Mokum Records,Peckerhead
51663 MOK171,Mokum Records,Peckerhead
51664 MOK171,Mokum Records,Peckerhead
51665 MOK171,Mokum Records,Peckerhead
51666 MOK171,Mokum Records,Peckerhead
51694 EXE067,Executive Records,Antix,Tom-E,Destiny,Rawmachine,Convict
51735 DJ G, The Pills, Ballistik Hardcore, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download The Pills (Original Mix) by Ballistik Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. BH044,Ballistik Hardcore,DJ G
51750 Lord of Hardcore, Work That Sukka!, Screwdriver, Original Mix, Hard Dance, Toolbox Digital Download Work That Sukka! (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw2,Screwdriver,Lord of Hardcore
51751 Lord of Hardcore, Freestyle Fanatic, Screwdriver, Original Mix, Hard Dance, Toolbox Digital Download Freestyle Fanatic (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw2,Screwdriver,Lord of Hardcore
51752 Lord of Hardcore, Attack The Dancefloor, Screwdriver, Original Mix, Hard Dance, Toolbox Digital Download Attack The Dancefloor (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw2,Screwdriver,Lord of Hardcore
51753 Lord of Hardcore, Scott Brown, Work That Sukka!, Screwdriver, Bass Control Mix, Hard Dance, Toolbox Digital Download Work That Sukka! (Bass Control Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw2,Screwdriver,Lord of Hardcore,Scott Brown
51768 ravenew2,Rave Essentials,Robyn,Overdrive,Bridson
51782 Eufeion, Kandie Rush, Tokie, Ninja Hardcore, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Tokie (Original Mix) by Ninja Hardcore from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. NINJAHCSE001,Ninja Hardcore,Eufeion,Kandie Rush
51785 Steven Davidson, Touch The Sky, Evolution Records, Original Mix, Hard Dance, Toolbox Digital Download Touch The Sky (Original Mix) by Evolution Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Ev153,Evolution Records,Steven Davidson
51786 Steven Davidson, Feel It, Evolution Records, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Feel 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. Ev153,Evolution Records,Steven Davidson
51788 PCR039,Peacock Records,Hyrule War
51789 PCR039,Peacock Records,Hyrule War
51790 PCR039,Peacock Records,Hyrule War,The Mastery
51791 PCR039,Peacock Records,Hyrule War
51792 PCR039,Peacock Records,Hyrule War,Sghenny
51793 PCR039,Peacock Records,Hyrule War
51794 PCR039,Peacock Records,Hyrule War,Sefa
51795 PCR039,Peacock Records,Hyrule War,Ohmboy
51796 PCR039,Peacock Records,Hyrule War
51797 PCR039,Peacock Records,Hyrule War
51798 PCR039,Peacock Records,Hyrule War,La Ravage
51799 PCR039,Peacock Records,Hyrule War
51800 PCR039,Peacock Records,Hyrule War
51801 PCR039,Peacock Records,Hyrule War,Dr. Peacock
51802 PCR039,Peacock Records,Hyrule War
51811 CBD3,Core Blimey Digital,Hyper,Kurt,Double D
51812 CBD4,Core Blimey Digital,Hyper,Joey Riot,MC Ricta
51813 Instigate, Joey Riot, It's Over Now, Scarred Digital, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download It's Over Now (Original Mix) by Scarred Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. SD096,Scarred Digital,Joey Riot,Instigate
51816 247HC105,24/7 Hardcore,Al Storm,Euphony
51828 247HC106,24/7 Hardcore,IYF,Nobody
51829 Bass-x, Morphine, Screwdriver, Original Mix, Featured Hardcore New, Hardcore, Toolbox Digital Download Morphine (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw4,Screwdriver,Bass-X
51830 Bass-x, Bass Nation, Screwdriver, Original Mix, Hard Dance, Toolbox Digital Download Bass Nation (Original Mix) by Screwdriver from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Screw4,Screwdriver,Bass-X
52214 DisorderLee, IYF, ROXIE, I Hold You, Universal Hardcore Digital, DisorderLee & IYF Remix, Featured Hardcore New, Hardcore, Toolbox Digital Download I Hold You (DisorderLee & IYF Remix) by Universal Hardcore Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. UHD101,Universal Hardcore Digital,IYF,Roxie,DisorderLee
59337 JH176,Justice Hardcore,Rocky-Star
91668 EX015,Exode Records,Razkor
91669 EX015,Exode Records,Razkor
91670 EX015,Exode Records,Razkor
111382 LTR048,Lethal Theory,Lady Dubbz