---> SELECT w.portal_name, w.portal_theme, w.portal_ownerID, w.portal_ownerType, w.auth_clntCd, w.portal_dataSource, w.portal_dataSource_preview, w.portal_dataSource_dev, w.portal_corpSiteURL, w.portal_corpSiteURL_preview, w.portal_corpSiteURL_dev, w.websiteid FROM tbl_CUS_WebSiteDomains d INNER JOIN tbl_CUS_WebSites w ON w.websiteid = d.websiteid WHERE d.domainname = AND w.portal_type = 'MFR' ---> ---> ---> ---> ---> ---> --->