SELECT 
  cscart_product_descriptions.product_id, 
  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 (
    43816, 43815, 43814, 43813, 43812, 43811, 
    43810, 43809, 43808, 43807, 43806, 
    43805, 43804, 43803, 43802, 43598, 
    43597, 43596, 43595, 43594
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00031

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 20 Using where

Result

product_id meta_keywords meta_description search_words promo_text
43594 LWEGHD13,LW Recordings,Siscokid,Christopher Playle
43595 BK, Sam Townend, Drop To Your Knees, LW Recordings, BK's SLAM! Remix, Hard Dance, Toolbox Digital Download Drop To Your Knees (BK's SLAM! Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,BK,Sam Townend
43596 LWEGHD13,LW Recordings,Noizy Boy
43597 Karl Davis, Get Blastin, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Get Blastin (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWEGHD13,LW Recordings,Karl Davis
43598 LWEGHD13,LW Recordings
43802 T-Factor, Tamerax, Ghost In A Shell, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Ghost In A Shell (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,T-Factor,Tamerax
43803 BK, Ilogik, Real Life, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Real Life (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,BK,Ilogik
43804 Daimon Hellstrom, Chopkicks, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Chopkicks (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Daimon Hellstrom
43805 Connected, Psychopath, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Psychopath (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Connected
43806 LWHDS07,LW Recordings,Bangerz & Masherz
43807 LWHDS07,LW Recordings,Nando Cp
43808 LWHDS07,LW Recordings,BloodDropz!
43809 Air Cralz, Dejotalberto, In The Mix, LW Recordings, Dejotalberto Remix, Hard Dance, Toolbox Digital Download In The Mix (Dejotalberto Remix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Air Cralz,Dejotalberto
43810 Hordy, Radiance, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Radiance (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Hordy
43811 Adam M, Master Blaster, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Master Blaster (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Adam M
43812 Valex, Waste Disposal, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Waste Disposal (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Valex
43813 LWHDS07,LW Recordings,Audio Hedz,Bret E Boy
43814 LWHDS07,LW Recordings,Rinski
43815 LWHDS07,LW Recordings,DJ Benchuscoro
43816 Adam Taylor, Kye Shand, Love On My Mind, LW Recordings, Original Mix, Hard Dance, Toolbox Digital Download Love On My Mind (Original Mix) by LW Recordings from Toolbox Digital, the UK’s number one outlet for exclusive hard dance, hard trance, hardcore, hardstyle and more. LWHDS07,LW Recordings,Adam Taylor,Kye Shand