select w.websiteid, w.name as SiteName, p.portletid, p.portlettitle, p.portletClass , p.portletConfig, p.websiteSectionIDList, p.excludeSectionIDList, p.permissionRequired, p.sortRank,p.comments from tbl_CUS_WebSitePortlets p inner join tbl_CUS_WebSites w on p.websiteid = w.websiteid where w.websiteid = and p.portletid = order by p.sortRank, p.portletTitle