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 (
    48473, 48713, 48706, 48297, 48920, 48671, 
    48670, 48302, 48276, 48275, 48238, 
    48270, 48271, 48266, 48265, 48264, 
    48263, 48246, 48277, 48247, 48259, 
    48258, 48257, 48256, 48255, 48248, 
    48237, 48236, 48233, 48201, 48103, 
    48102, 48267, 48047, 48192, 48120, 
    48101, 48100, 48099, 48097, 47985, 
    47984, 48078, 48046, 48410, 48409, 
    48408, 48407, 48406, 48405, 48404, 
    48403, 48402, 48401, 48400, 48399, 
    48398, 48397, 48396, 48395, 48394, 
    48393, 48392, 48391, 48390, 48389, 
    48388, 48387, 48386, 48385, 48384, 
    48383, 48382, 48381, 48380, 48379, 
    48378, 48377, 48376, 48375
  ) 
  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
  )