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 (
    61885, 61787, 61767, 61766, 61519, 61518, 
    61116, 60266, 59324, 61789, 61788, 
    61217, 59956, 61633, 61112, 61007, 
    61006, 60975, 60963, 60854, 60265, 
    61632, 61613, 61523, 61583, 61565, 
    58785, 61509, 61418, 61407, 61406, 
    61391, 61016, 60853, 60264, 59808, 
    61508, 60867, 61409, 61157
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00050

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
58785 Neil Bee, Speed Riddem, Fireball, Exclusive, Toolbox Digital Download Speed Riddem by Fireball from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
59324
59808 Smart & Mumbles, Fallout, Hard House, Encoded Smart & Mumbles, Fallout, Hard House, Encoded
59956
60264
60265
60266
60853 craig,mac,hardhouse,premonitiondigital,harddance,hard,vocal craig,mac,hardhouse,premonitiondigital,harddance,hard,vocal
60854 frankfarrell,randombutraw,kidrich,hardhouse,premonition,premonitiondigital,harddance,hardnrg frankfarrell,randombutraw,kidrich,hardhouse,premonition,premonitiondigital,harddance,hardnrg,bug,hunt,bughunt
60867 The Snail, Sabotaged, Digital Snail, Exclusive, Toolbox Digital Download Sabotaged by Digital Snail from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. The Snail, Sabotaged, Digital Snail, Hard House
60963 Encoded, Dawn Lee, Breathe, Frantic Digital, Hard House Encoded / Dawn Lee / Breathe / Frantic Digital / Hard House
60975 DB014,Drop Bear Digital ,Dale West,Sean Inside Out
61006 Mac 'N' Cheese, Hard House, Tim Clewz, Jamie Haig, Welovehardhouse MAc N' Cheese, Hard House, Tim Clewz, Jamie Haig, Welovehardhouse
61007 Mac 'N' Cheese, Hard House, Tim Clewz, Jamie Haig, Welovehardhouse Mac 'N' Cheese, Hard House, Tim Clewz, Jamie Haig, Welovehardhouse
61016 TT010a,Tuff Trax,Jade Paley,Sam Alame,Damaged Gudz
61112 TT011a,Tuff Trax,Marc Lewis
61116 TT012a,Tuff Trax,Boris The Noss
61157
61217 FE093,Fatal Energy Records,Noizy Boy,Muzz
61391 Nikkdbubble, Fist Pump, Mangled Wreck Chords, Exclusive, Toolbox Digital Download Fist Pump by Mangled Wreck Chords from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. Nikkdbubble,dexitron,hardhouse,hard,house,NRG,AdelaideNRG,
61406 Marco,V,Jens,Loops,N,Tings,Things,Relooped,Wayne,Smart,Matt,Adam,Neverland,Recordings,Remix,Rework,Bootleg The last of our summer releases comes in the form of a production masterclass with Wayne Smart collaborating with New Zealand’s Matt Adam in the TurtleDog Studio. Their rework is a polished up dated beast of a track which encompasses everything our label’ Marco,V,Jens,Loops,N,Tings,Things,Relooped,Wayne,Smart,Matt,Adam,Neverland,Recordings,Remix,Rework,Bootleg
61407 DeXiTroN, Fist Pump, Mangled Wreck Chords, Exclusive, Toolbox Digital Download Fist Pump by Mangled Wreck Chords from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
61409 Dale West, COMMUNICATION BREAKDOWN, WiggleCat Records, Exclusive, Toolbox Digital Download COMMUNICATION BREAKDOWN by WiggleCat Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. COMMUNICATION BREAKDOWN,Date West,WiggleCat Records,
61418
61508
61509 Jeff Payne, Ben Stevens, Digital Drugs, Solid State Digital, SSD024 Jeff Payne & Ben Stevens - Digital Drugs Released on Solid State Digital Jeff Payne, Ben Stevens, Digital Drugs, Solid State Digital, SSD024
61518 Cheek339,Cheeky Tracks,Venkman
61519 Cheek339,Cheeky Tracks,Venkman
61523 TMP090,Matt Wade,Outta My Mind,Tempo Trax.Hard House Hard House TMP090,Matt Wade,Outta My Mind,Tempo Trax.Hard House
61565 Random but Raw, Hard House, Orrible Noize
61583 DeXiTroN, Nikkdbubble, DeXiTroN & Nikkdbubble - Fist Pump EP, Mangled Wreck Chords, Exclusive, Toolbox Digital Download DeXiTroN & Nikkdbubble - Fist Pump EP by Mangled Wreck Chords from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
61613
61632 Keep it up, Speak Up Records, Exclusive, Toolbox Digital Download Keep it up by Speak Up Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
61633 Hey,Boy,Hey,Girl,Remix,Rework,Vocal,Bootleg,Superstar,DJ,DJs,Here,We,Go,Ben,Macdonald,Chucky,Chemical,Brothers,Helix,Recordings Chucky makes a second appearance on the label returning off the back of his number one release "A Little More". His second release uses some familiar 90s vocals a big trance riff and hoover stabs over and off beat bassline bringing it all into a track whi Hey,Boy,Hey,Girl,Remix,Rework,Vocal,Bootleg,Superstar,DJ,DJs,Here,We,Go,Ben,Macdonald,Chucky,Chemical,Brothers,Helix,Recordings
61766 The Freak Brothers, Ready To Ride, Vicious Circle, VIP Hoover Mix, Exclusive, Toolbox Digital Download Ready To Ride (VIP Hoover Mix) by Vicious Circle from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
61767
61787
61788 Happy Days Energy Source Productions Hard House DJ Serenity Happy Days Energy Source Productions Hard House DJ Serenity Happy Days Energy Source Productions Hard House DJ Serenity
61789 Raise Your Hands Energy Source Productions Hard House DJ Serenity Raise Your Hands Energy Source Productions Hard House DJ Serenity Raise Your Hands Energy Source Productions Hard House DJ Serenity
61885 TMP091,Matt Clarkson,Dream Your Dream,Tempo Trax, Hard House Hard House TMP091,Matt Clarkson,Dream Your Dream,Tempo Trax, Hard House