SELECT w.auth_CustFldr, w.auth_AppName, w.auth_LoginSecureIDs, w.auth_ReminderSiteName, w.auth_ReminderFromAddy, w.auth_LoginHelpAddy, c.FSL_CompanyID, c.FSL_TableCode, w.websiteid, w.auth_GenericBrokerPortalLogin FROM fsenablers..tbl_CUS_Websites w, fsenablers..tbl_CUS_Customers c WHERE w.portal_ownerId = and w.portal_ownerType = AND w.CustomerID = c.CustomerID select fspro_userId, email, firstName, lastName from tbl_fspro_members where fspro_userId = and fspro_password = select fspro_UserId, passwordLock, email, firstName, lastName from tbl_fspro_Members with (nolock) where fspro_userId = select count(*) as attempts from tbl_TRK_MemberActivity with (nolock) where cfid_login = and eventcd = 'LF' and fspro_UserId = and datediff( minute, eventtime, getdate() ) < 10 and eventtime > ( select max(eventtime) from tbl_TRK_MemberActivity with (nolock) where eventcd = 'LI' and fspro_UserId = ) update tbl_fspro_members set passwordlock = 0 where fspro_userid = update tbl_fspro_members set passwordlock = 1 where fspro_userid = update tbl_Fspro_members set fspro_password = , fspro_password_method = , changePasswordRequired = null, passwordLastChangeDate = , passwordLock = 0 where fspro_userId = and fspro_password = and = ; select count(*) as attempts from tbl_TRK_MemberActivity with (nolock) where cfid_login = and eventcd = 'LF' and fspro_UserId = and datediff( minute, eventtime, getdate() ) < 10 and eventtime > ( select max(eventtime) from tbl_TRK_MemberActivity with (nolock) where eventcd = 'LI' and fspro_UserId = ) update tbl_fspro_members set passwordlock = 0 where fspro_userid = update tbl_fspro_members set passwordlock = 1 where fspro_userid = #serializeJSON( arguments.response )#