SELECT [UserID]
,[GameID]
,[ProtectID]
,[PasswordID]
,[SpreaderID]
,[Accounts]
,[NickName]
,[LastLogonIP]
,[LastLogonDate]
,[LastLogonMobile]
,[LastLogonMachine]
,[RegisterIP]
,[RegisterDate]
FROM [QPAccountsDB].[dbo].[AccountsInfo] where
IsAndroid = 0 and
DATEDIFF(DAY,LastLogonDate,GETDATE()) >= 30
order by LastLogonDate asc
未经允许不得转载! 作者:棋牌源码网,转载或复制请以超链接形式并注明出处棋牌源码网。
原文地址:《网狐框架清理30天未登录的账号》发布于:2021-08-09