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 (
    124642, 124641, 124640, 124639, 124638, 
    124637, 124636, 124635, 124634, 124633, 
    124632, 124631, 124630, 124629, 124628, 
    124627, 124626, 124625, 124624, 124623, 
    124622, 124621, 124620, 124619
  ) 
  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
  )