select w.websiteid, w.name as SiteName, s.sectionid, s.name, s.uri, s.parentsectionid, s.requiredpermission, s.menuSelectionCode, s.displayRank, s.hrefTarget, s.onClick, s.live, w.portal_ownerId, w.portal_ownerType, w.portal_name from fsenablers..tbl_CUS_WebSitesections s inner join fsenablers..tbl_CUS_WebSites w on s.websiteid = w.websiteid where w.websiteid = and s.sectionId = order by displayRank, s.name, parentsectionid