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 (
    68835, 69400, 69349, 69324, 69291, 69257, 
    69256, 69255, 69123, 68831, 68697, 
    68696, 68879, 68906, 68576, 69176, 
    69175, 69174, 69033, 67842, 69173, 
    69172, 69100, 69099, 69032, 69022, 
    68905, 68408, 68368, 68367, 68695, 
    68547, 68555, 68904, 68903, 68834, 
    68833, 68725, 68605, 68292
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00056

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
67842
68292 TT024a,Tuff Trax,Psydef
68367 Cheek377,Cheeky Tracks,Jamie Tennant
68368 Cheek377,Cheeky Tracks,Jamie Tennant
68408 DB026,Drop Bear Digital ,Matt Wade,Pez,Marc Coyne
68547 IR030,Innervate Records,Noath
68555 HOT009,Hot Box Digital,Pez
68576 UTHHD023,Ultratech,VaderMonkey
68605 Mark Hard Dan Dyson Onyx Hooverweight Mark Hard Dan Dyson Onyx Hooverweight
68695 Sean Inside Out, Vandalize, Been There Done That, Inside Out Digital, Exclusive, Toolbox Digital Download Been There Done That by Inside Out Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
68696 Marc Lewis, Sean Inside Out, Been There Done That, Inside Out Digital, Exclusive, Toolbox Digital Download Been There Done That by Inside Out Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
68697 Dean Drake Liddell, Sean Inside Out, Been There Done That, Inside Out Digital, Exclusive, Toolbox Digital Download Been There Done That by Inside Out Digital from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
68725 TMP107,Random But Raw,Face It All,Tempo Trax,Hard House Hard House TMP107,Random But Raw,Face It All,Tempo Trax,Hard House
68831 AAA164,Ahura Mazda Recordings NITRO,Burak Harsitlioglu
68833
68834 SLENDERMAN, Perfect Composure, Fruition Records, Exclusive, Toolbox Digital Download Perfect Composure by Fruition Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more.
68835 Cheek380,Cheeky Tracks,Matt Wade,Joe Swales
68879 HOT010,Hot Box Digital,Kirk P
68903 Filth, Gem Stone, Raw Power, Synths, Hoovers, RPR175, The Trip, Hard House, NRG Raw Power's very own Gem Stone certainly takes you on a trip with this tune! The bass carries the synth work and hoovers perfectly. Definitely one for the collection! Filth, Gem Stone, Raw Power, Synths, Hoovers, RPR175, The Trip, Hard House, NRG
68904 Tempted, Temptation, Gem Stone, Raw Power, Synths, RPR176, Hard House What's this? A Gem Stone track with vocals in it?! Surely not! Another one from the head of RPR herself, Gem Stone has something a little tempting for you... with a reworked trance classic, you just have to sing along to! Tempted, Temptation, Gem Stone, Raw Power, Synths, RPR176, Hard House
68905 premonition digital,gaz f,neil bee,ben stevens,music,hardhouse,filth,nrg,rave,tidy trax,tidy premonition digital,gaz f,neil bee,ben stevens,music,hardhouse,filth,nrg,funky,rave,tidy trax,tidy
68906 Toryn D,Kashi,Pentathol,The Truth,MHR,Mental Health Records,Ollie Jaye,Acid Animal,Swankie DJ 3 or maybe 4 years ago these two welsh wonders hit the studio and created this, its been sat on 2 hard drives ever since as life can take over, but the LRU studio computer got fired up one final time so here it is! Completing this MHR release is a Pero Re Toryn D,Kashi,Pentathol,The Truth,MHR,Mental Health Records,Ollie Jaye,Acid Animal,Swankie DJ
69022 James Price, Aaron James, Beef Brisket, Jeli Jams, Exclusive, Toolbox Digital Next release we have Aaron James debuting on Jeli Jams. Aaron has been making big waves in the scene over the last few years and is not a stranger to hitting the top spot on Toolbox Digital. He teams up with label manager James for this ‘beefy’ little num James Price, Aaron James, Beef Brisket, Jeli Jams, Exclusive, Toolbox Digital, Hard Jeli
69032 Marc Lewis Marc Lewis
69033 Digital Elements Collective Digital Elements Collective
69099 AL G, Rusko, Bootleg AL G, Rusko, Bootleg AL G, Rusko, Bootleg, Everybody's Lookin
69100 Skol , Woop Woop, 420 Rekords Skol , Woop Woop, 420 Rekords Skol , Woop Woop, 420 Rekords
69123 Damaged Gudz, Cheezy BumBum check, Hooverweight Records, Exclusive, Toolbox Digital Download Cheezy BumBum check by Hooverweight Records from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. damaged gudz cheezy bum
69172
69173 jud,roper,frank,farrell,gorra,get,off,hard,house,flat,4,audio A stand out dose of medieval rushy goodness. jud,roper,frank,farrell,gorra,get,off,hard,house,flat,4,audio
69174 Junction 33, UFO, Matt Clarkson, Cupra, Slingshot Junction 33, UFO, Matt Clarkson, Cupra, Slingshot
69175 Matt Wade & Pez, Can't Deny You, Solid State Digital, SSD033 Matt Wade & Pez - Can't Deny You Released on Solid State Digital Matt Wade & Pez, Can't Deny You, Solid State Digital, SSD033
69176
69255 premonition digital,g-mix,ben stevens,music,hardhouse,filth,nrg,rave,tidy trax,tidy premonition digital,g-mix,ben stevens,music,hardhouse,filth,nrg,rave,tidy trax,tidy
69256
69257 Asylum Asylum
69291 ram,rise,hard,house,classic,flat,4,audio Nostalgic whopper from the fresh faced RAM. ram,rise,hard,house,classic,flat,4,audio
69324 Ben Kaye, G.S.R, On The Fence, Jump Trax, Exclusive, Toolbox Digital Download On The Fence by Jump Trax from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. G.S.R Ben Kaye Jump Trax
69349
69400 TMP108,John Reilly,I Can't Hold It,Tempo Trax,Hard House Hard House TMP108,John Reilly,I Can't Hold It,Tempo Trax,Hard House