SELECT Email FROM tbl_FSPro_Members WHERE FSPro_UserID = SELECT a.ActivityID, a.UserName, a.CompanyName, a.IP_Address, a.Site, a.EventCD, a.EventTime, a.EventDetail, 'STD' as LoginType, w.Name AS WebSiteName FROM tbl_TRK_MemberActivity a, FSEnablers.dbo.tbl_CUS_Websites w WHERE a.FSPro_UserID = AND a.EventCD = 'LI' AND a.site LIKE 'salesteamportal_%' AND replace(a.site,'salesteamportal_','') = w.websiteId UNION SELECT a.ActivityID, a.UserName, a.CompanyName, a.IP_Address, a.Site, a.EventCD, a.EventTime, a.EventDetail, 'CAA' as LoginType, w.Name AS WebSiteName FROM tbl_TRK_MemberActivity a, FSEnablers.dbo.tbl_CUS_Websites w, tbl_FSPro_Members m WHERE a.EventDetail LIKE AND a.EventCD = 'LI' AND a.site LIKE 'salesteamportal_%' AND replace(a.site,'salesteamportal_','') = w.websiteId AND a.FSPro_UserID = m.FSPro_UserID AND m.clientSTPAdminUser = 'Y' ORDER BY EventTime desc
Date/Time Site IP Address Login Type
#dateformat(qmd_getMemberActivity.EventTime,"mmmm d, yyyy")#
#timeformat(qmd_getMemberActivity.EventTime)#		 #qmd_getMemberActivity.WebSiteName# #qmd_getMemberActivity.IP_Address# #qmd_getMemberActivity.LoginType# *
Administrator Access : #qmd_getMemberActivity.UserName#