1
0.22 ms
SELECT name , value FROM stats_config
SELECT name , value FROM stats_config ;
Copy
2
0.26 ms
SELECT GUID FROM stats_players_static WHERE stats_players_static . ISBANNED = 1
SELECT GUID FROM stats_players_static WHERE stats_players_static . ISBANNED = 1 ;
Copy
3
0.27 ms
SELECT COUNT (* ) FROM (SELECT count (stats_players . GUID ) as AllPlayersCount FROM stats_players WHERE Kills > 25 GROUP BY GUID ORDER BY Kills DESC ) AS cnt_sub
SELECT COUNT (* ) FROM (SELECT count (stats_players . GUID ) as AllPlayersCount FROM stats_players WHERE Kills > 25 GROUP BY GUID ORDER BY Kills DESC ) AS cnt_sub ;
Copy
4
0.30 ms
SELECT stats_players . GUID , sum (stats_players . Kills ) as Kills , sum (stats_players . Deaths ) as Deaths , sum (stats_players . Teamkills ) as Teamkills , sum (stats_players . Suicides ) as Suicides , sum (stats_players . Kills ) / sum (stats_players . Deaths ) as KillRatio FROM stats_players WHERE Kills > 25 GROUP BY stats_players . GUID ORDER BY Kills DESC LIMIT 0 , 50
SELECT stats_players . GUID , sum (stats_players . Kills ) as Kills , sum (stats_players . Deaths ) as Deaths , sum (stats_players . Teamkills ) as Teamkills , sum (stats_players . Suicides ) as Suicides , sum (stats_players . Kills ) / sum (stats_players . Deaths ) as KillRatio FROM stats_players WHERE Kills > 25 GROUP BY stats_players . GUID ORDER BY Kills DESC LIMIT 0 , 50 ;
Copy
5
0.22 ms
SELECT stats_aliases . PLAYERID , stats_aliases . Alias , stats_aliases . AliasAsHtml FROM stats_aliases LEFT OUTER JOIN (stats_players_topalias ) ON (stats_aliases . ID = stats_players_topalias . ALIASID ) WHERE stats_players_topalias . GUID IN (4184764196 , 1420733202 , 682876912 , 1008427758 , 2601224506 , 4279534630 , 3369242101 , 1086709141 , 516204237 , 24882786 , 2079358852 , 4293707123 , 4108050209 , 2378959285 , 1411893074 ) AND stats_players_topalias . SERVERID = - 1 GROUP BY stats_aliases . PLAYERID
SELECT stats_aliases . PLAYERID , stats_aliases . Alias , stats_aliases . AliasAsHtml FROM stats_aliases LEFT OUTER JOIN (stats_players_topalias ) ON (stats_aliases . ID = stats_players_topalias . ALIASID ) WHERE stats_players_topalias . GUID IN (4184764196 , 1420733202 , 682876912 , 1008427758 , 2601224506 , 4279534630 , 3369242101 , 1086709141 , 516204237 , 24882786 , 2079358852 , 4293707123 , 4108050209 , 2378959285 , 1411893074 ) AND stats_players_topalias . SERVERID = - 1 GROUP BY stats_aliases . PLAYERID ;
Copy
6
0.26 ms
SELECT stats_time . PLAYERID , sum (stats_time . TIMEPLAYED ) as TotalSeconds FROM stats_time WHERE stats_time . PLAYERID IN (4184764196 , 1420733202 , 682876912 , 1008427758 , 2601224506 , 4279534630 , 3369242101 , 1086709141 , 516204237 , 24882786 , 2079358852 , 4293707123 , 4108050209 , 2378959285 , 1411893074 ) GROUP BY stats_time . PLAYERID
SELECT stats_time . PLAYERID , sum (stats_time . TIMEPLAYED ) as TotalSeconds FROM stats_time WHERE stats_time . PLAYERID IN (4184764196 , 1420733202 , 682876912 , 1008427758 , 2601224506 , 4279534630 , 3369242101 , 1086709141 , 516204237 , 24882786 , 2079358852 , 4293707123 , 4108050209 , 2378959285 , 1411893074 ) GROUP BY stats_time . PLAYERID ;
Copy
7
0.22 ms
SELECT sum (stats_players . Kills ) / sum (stats_players . Deaths ) as MaxKillRatio FROM stats_players WHERE Kills > 25 GROUP BY stats_players . GUID ORDER BY MaxKillRatio DESC LIMIT 1
SELECT sum (stats_players . Kills ) / sum (stats_players . Deaths ) as MaxKillRatio FROM stats_players WHERE Kills > 25 GROUP BY stats_players . GUID ORDER BY MaxKillRatio DESC LIMIT 1 ;
Copy
8
0.09 ms
SELECT ID , Name FROM stats_servers ORDER BY ID
SELECT ID , Name FROM stats_servers ORDER BY ID ;
Copy
9
0.19 ms
SELECT DISTINCT stats_time . Time_Year , stats_time . Time_Month FROM stats_time ORDER BY stats_time . Time_Year DESC , stats_time . Time_Month DESC
SELECT DISTINCT stats_time . Time_Year , stats_time . Time_Month FROM stats_time ORDER BY stats_time . Time_Year DESC , stats_time . Time_Month DESC ;
Copy
10
0.27 ms
SELECT stats_weapons . ID as WEAPONID , stats_weapons . INGAMENAME , stats_weapons . DisplayName as WeaponDisplayName , stats_weapons . WeaponType FROM stats_weapons ORDER BY stats_weapons . WeaponType , stats_weapons . INGAMENAME
SELECT stats_weapons . ID as WEAPONID , stats_weapons . INGAMENAME , stats_weapons . DisplayName as WeaponDisplayName , stats_weapons . WeaponType FROM stats_weapons ORDER BY stats_weapons . WeaponType , stats_weapons . INGAMENAME ;
Copy
11
0.09 ms
SELECT stats_gametypes . ID as GAMETYPEID , stats_gametypes . NAME , stats_gametypes . DisplayName as GameTypeDisplayName FROM stats_gametypes ORDER BY stats_gametypes . NAME
SELECT stats_gametypes . ID as GAMETYPEID , stats_gametypes . NAME , stats_gametypes . DisplayName as GameTypeDisplayName FROM stats_gametypes ORDER BY stats_gametypes . NAME ;
Copy
12
0.08 ms
SELECT stats_damagetypes . DAMAGETYPE , stats_damagetypes . DisplayName FROM stats_damagetypes ORDER BY stats_damagetypes . DisplayName , stats_damagetypes . DAMAGETYPE
SELECT stats_damagetypes . DAMAGETYPE , stats_damagetypes . DisplayName FROM stats_damagetypes ORDER BY stats_damagetypes . DisplayName , stats_damagetypes . DAMAGETYPE ;
Copy
13
0.40 ms
SELECT stats_consolidated . NAME , stats_consolidated . DisplayName , stats_consolidated . VALUE_INT , stats_consolidated . VALUE_TXT , stats_consolidated . DescriptionID , stats_language_strings . TEXT as Description FROM stats_consolidated LEFT OUTER JOIN (stats_language_strings ) ON (stats_language_strings . STRINGID = stats_consolidated . DescriptionID ) WHERE stats_consolidated . NAME LIKE 'global_%' AND stats_consolidated . Time_Year = 0 AND stats_consolidated . Time_Month = 0 ORDER BY stats_consolidated . SortID
SELECT stats_consolidated . NAME , stats_consolidated . DisplayName , stats_consolidated . VALUE_INT , stats_consolidated . VALUE_TXT , stats_consolidated . DescriptionID , stats_language_strings . TEXT as Description FROM stats_consolidated LEFT OUTER JOIN (stats_language_strings ) ON (stats_language_strings . STRINGID = stats_consolidated . DescriptionID ) WHERE stats_consolidated . NAME LIKE 'global_%' AND stats_consolidated . Time_Year = 0 AND stats_consolidated . Time_Month = 0 ORDER BY stats_consolidated . SortID ;
Copy
14
0.13 ms
SELECT stats_consolidated . NAME , stats_consolidated . DisplayName , stats_consolidated . VALUE_INT FROM stats_consolidated WHERE stats_consolidated . NAME LIKE 'server_total%' AND stats_consolidated . SERVERID = - 1 AND stats_consolidated . Time_Year = 0 AND stats_consolidated . Time_Month = 0 ORDER BY stats_consolidated . SortID
SELECT stats_consolidated . NAME , stats_consolidated . DisplayName , stats_consolidated . VALUE_INT FROM stats_consolidated WHERE stats_consolidated . NAME LIKE 'server_total%' AND stats_consolidated . SERVERID = - 1 AND stats_consolidated . Time_Year = 0 AND stats_consolidated . Time_Month = 0 ORDER BY stats_consolidated . SortID ;
Copy