27,579
社区成员
发帖
与我相关
我的任务
分享
--加一个索引:
create index ix_RecordDrawScore_DrawID_Filter on RecordDrawScore(DrawID) where (Score != 0)
go
--查询代码美化一下
SELECT A.DrawID,
A.KindID,
A.ServerID,
A.TableID,
A.UserCount,
A.AndroidCount,
A.Waste,
A.Revenue,
A.UserMedal,
A.StartTime,
A.ConcludeTime,
A.InsertTime,
B.KindName,
C.ServerName,
D .Score AS Score,
d .BackScore AS BackScore,
D .BackInsureScore,
E.gameid,
E.accounts,
E.nickname,
D .changeIp AS lastlogonip,
E.LastLogonType,
E.userID
FROM [QPTreasureDB].[dbo].RecordDrawInfo AS A
LEFT JOIN QPPlatformDB.dbo.GameKindItem AS B
ON A.KindID = B.KindID
LEFT JOIN QPPlatformDB.dbo.GameRoomInfo AS C
ON A.ServerID = C.ServerID
JOIN QPTreasureDB.dbo.RecordDrawScore AS D
ON A.DrawID = D .DrawID
LEFT JOIN QPAccountsDB.dbo.AccountsInfo AS E
ON D .UserID = E.userID
WHERE d .Score != 0
AND a.InsertTime >= DATEADD(dd, - 7, GETDATE())
ORDER BY
a.InsertTime DESC