奖牌牛人榜 - 白金岛活动专区

select top 50 ChrID,NikeName=(select top 1 NikeName from t_MatchRecord where chrid=T.chrid and MatchOrd=1 order by matchTime desc),topNum1=COUNT(*),topNum2 = (select count(*) from t_MatchRecord A left join BJD_MatchConfig B on A.GameID=B.GameID and A.MatchID=B.MatchID where chrid=T.chrid and A.MatchOrd=2 and (B.RID is Not null) and A.matchTime>='2024-03-29 12:28:42' ),topNum3 = (select count(*) from t_MatchRecord A left join BJD_MatchConfig B on A.GameID=B.GameID and A.MatchID=B.MatchID where chrid=T.chrid and A.MatchOrd=3 and (B.RID is Not null) and A.matchTime>='2024-03-29 12:28:42' )from (select A.Chrid,A.MatchOrd from t_MatchRecord A left join BJD_MatchConfig B on A.GameID=B.GameID and A.MatchID=B.MatchID where A.MatchOrd=1 and (B.RID is Not null) and A.matchTime>='2024-03-29 12:28:42' ) T where T.MatchOrd=1 group by T.ChrID,T.MatchOrd order by COUNT(*) desc
System.Data.SqlClient.SqlException (0x80131904): 缓冲池中的可用内存不足。在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 在 System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) 在 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) 在 System.Data.SqlClient.SqlDataReader.Read() 在 System.Data.Common.DbEnumerator.MoveNext() 在 System.Web.UI.WebControls.Repeater.AddDataItemsIntoItemsArray(IEnumerable dataSource, Boolean useDataSource) 在 System.Web.UI.WebControls.Repeater.PostGetDataAction(IEnumerable dataSource) 在 System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) 在 System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) 在 System.Web.UI.WebControls.Repeater.DataBind() 在 DataBase.DataBaseTool.BindData_toRepeater(String QueryStr, Int32 PageSize, Int32 PageCurrent, String FdShow, String FdOrder, Repeater Repeater1) ClientConnectionId:ac91d32c-7828-4a79-ab50-dc86861f6662 Error Number:802,State:20,Class:17
奖牌牛人榜 - 白金岛活动专区

您还未登录，请[登录]

大赛殊荣：

历史战绩：
第一名	第二名	第三名

推荐活动

热门比赛

奖牌牛人榜

昵称

冠军

亚军

季军