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 (
    49149, 49292, 49124, 49123, 49122, 49121, 
    49119, 49115, 49114, 49092, 49089, 
    49088, 49087, 49086, 49085, 49075, 
    49054, 49053, 48987, 48986, 48985, 
    48984, 48983, 109922, 109921, 109920, 
    109919, 49051, 49050, 49049, 49048, 
    49047, 49046, 49045, 49044, 49043, 
    49042, 49041, 49040, 48967, 48965, 
    48964, 48959, 48958, 48957, 48956, 
    48955, 48954, 48953, 48952, 48951, 
    48950, 49263, 49162, 48988, 49265, 
    48921, 48885, 48884, 48883, 48882, 
    49373, 49372, 49371, 49370, 49369, 
    49368, 49367, 49366, 49365, 49364, 
    49363, 49362, 49361, 49360, 49359, 
    49358, 49357, 49356, 49355
  ) 
  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
  )