网狐框架清理30天未登录的账号

棋牌技***

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 LastLogonDa框架读音te asc

游客，如果您要查看本帖隐藏内容请回复