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 (
    68534, 68533, 68459, 68363, 68362, 68360, 
    68358, 68357, 68135, 68065, 68064, 
    67902, 67896, 67685, 67684, 66983, 
    68359, 67955, 68319, 68312, 67848, 
    67845, 67839, 67686, 67683, 66841, 
    66840, 66839, 67958, 68200, 67770, 
    67769, 67768, 67767, 67766, 67765, 
    67764, 67763, 67762, 67761
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00058

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
66839 The Bounce Factory , TBF, Bounce, Donk, Tom Berry The Bounce Factory , TBF, Bounce, Donk, Tom Berry The Bounce Factory , TBF, Bounce, Donk, Tom Berry
66840 The Bounce Factory , TBF, Bounce, Donk, Tom Berry The Bounce Factory , TBF, Bounce, Donk, Tom Berry The Bounce Factory , TBF, Bounce, Donk, Tom Berry
66841 The Bounce Factory , TBF, Bounce, Donk, Tom Berry The Bounce Factory , TBF, Bounce, Donk, Tom Berry The Bounce Factory , TBF, Bounce, Donk, Tom Berry
66983
67683
67684
67685
67686
67761
67762
67763
67764
67765
67766
67767
67768
67769
67770
67839
67845
67848 TT021a,Tuff Trax,Damaged Gudz
67896 TT022a,Tuff Trax,Chaney
67902 FE140,Fatal Energy Records,STRIX
67955 HOT007,Hot Box Digital,Matt Wade,Miric
67958 AAA161,Ahura Mazda Recordings NITRO,Burak Harsitlioglu
68064 Cheek373,Cheeky Tracks,Alan Sharkey
68065 Cheek373,Cheeky Tracks,Alan Sharkey
68135 premonition,premonition digital, premonition artitst,joe longbottom,ben diesel,hard house,filth,nrg,tidy,bruce lee,music premonition,premonition digital, premonition artitst,joe longbottom,ben diesel,hard house,filth,nrg,tidy,bruce lee,music
68200 TMP105,Matt Clarkson,No More Games,Tempo Trax,Hard House Hard House TMP105,Matt Clarkson,No More Games,Tempo Trax,Hard House
68312 Teresa Bint, Binty, Feel the Fire Burn, Jeli Jams, Exclusive, Toolbox Digital Next up we have a fresh name to the label. We are proud to announce that Teresa Bint aka Binty is featuring on Jeli Jams with this big vocal anthem. Receiving great feedback so far this is sure to go down well in your sets. A meaty rolling bassline, dirty Teresa Bint, Binty, Feel the Fire Burn, Jeli Jams, Exclusive, Toolbox Digital, Hard Jeli, James Price, Selina Ridgway
68319 Bry,Randall,Rude,Bitch,B*tch,Flat,4,Audio,Hard,House,NRG Nostalgic slammer fresh from the south coast! Bry,Randall,Rude,Bitch,B*tch,Flat,4,Audio,Hard,House,NRG
68357 Frantic Digital, Hard House, Damien Blanes, Dave Owens, Lets Begin Frantic Digital, Hard House, Damien Blanes, Dave Owens, Lets Begin
68358 The Bounce Factory , TBF, Bounce, Donk The Bounce Factory , TBF, Bounce, Donk
68359
68360 D-Fi, Chucky D-Fi, Chucky
68362
68363 Paul King vs Bass Jumper, I'll Be There 4 U, Solid State Digital, SSD032 Paul King vs Bass Jumper - I'll Be There 4 U Released on Solid State Digital Paul King vs Bass Jumper, I'll Be There 4 U, Solid State Digital, SSD032
68459
68533 Damaged Gudz, Hard House, 420 Rekords Damaged Gudz, Hard House, 420 Rekords Damaged Gudz, Hard House, 420 Rekords
68534 Sean Inside Out & Dale West, 420 Rekords, Hard House Sean Inside Out & Dale West, 420 Rekords, Hard House Sean Inside Out & Dale West, 420 Rekords, Hard House