SELECT t_pages.page_id, t_pages.page_name, t_pages.logical_name, t_sites.site_title, t_sites.test_domain, t_sites.prod_domain, t_sites.local_server 
 From t_pages INNER JOIN t_sites ON t_pages.site_id = t_sites.site_id 
WHERE (t_pages.page_id = '5883') AND (t_pages.site_id = 283) and isnull(is_deleted,0) = 0