SELECT 
  cscart_seo_names.object_id AS product_id, 
  cscart_seo_names.name AS seo_name, 
  cscart_seo_names.path AS seo_path 
FROM 
  cscart_seo_names 
WHERE 
  cscart_seo_names.object_id IN (
    94742, 94741, 94740, 94739, 94738, 94737, 
    94736, 94735, 94734, 94733, 94732, 
    94731, 94730, 94729, 94728, 94727, 
    95619, 95618, 95617, 95616, 95615, 
    95614, 95613, 95612, 95611, 95610, 
    95609, 95608, 95607, 95606, 95605, 
    95604, 95603, 95602, 95601, 95600, 
    95599, 95598, 95597, 95596
  ) 
  AND cscart_seo_names.type = "p" 
  AND cscart_seo_names.dispatch = "" 
  AND cscart_seo_names.lang_code = 'en' 
  AND (
    cscart_seo_names.company_id = 1 
    OR cscart_seo_names.company_id = 0
  )