from sitesRow in DC.Sites
join sitesContextRow in DC.SitesContents on sitesRow.SiteID equals sitesContextRow.SiteContentID into temp
from all in temp.DefaultIfEmpty()
where (all.SiteContentID == null) && (sitesRow.DomainID == domain.DomainID)
orderby sitesRow.Rank descending
select sitesRow