1
0.21 ms
SELECT name , value FROM stats_config
SELECT name , value FROM stats_config ;
Copy
2
0.33 ms
SELECT * FROM stats_servers WHERE ID = ?
SELECT * FROM stats_servers WHERE ID = 1 ;
Copy
3
0.19 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
4
0.27 ms
SELECT COUNT (* ) FROM (SELECT count (stats_players . GUID ) as AllPlayersCount FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 GROUP BY GUID ORDER BY KillRatio DESC ) AS cnt_sub
SELECT COUNT (* ) FROM (SELECT count (stats_players . GUID ) as AllPlayersCount FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 GROUP BY GUID ORDER BY KillRatio DESC ) AS cnt_sub ;
Copy
5
0.31 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 AND stats_players . SERVERID = 1 GROUP BY stats_players . GUID ORDER BY KillRatio 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 AND stats_players . SERVERID = 1 GROUP BY stats_players . GUID ORDER BY KillRatio DESC LIMIT 0 , 50 ;
Copy
6
0.21 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 (1411893074 , 4279534630 , 682876912 , 4184764196 , 24882786 , 1420733202 , 4293707123 , 2601224506 , 516204237 , 1086709141 , 1008427758 , 2079358852 , 3369242101 , 2378959285 , 4108050209 ) 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 (1411893074 , 4279534630 , 682876912 , 4184764196 , 24882786 , 1420733202 , 4293707123 , 2601224506 , 516204237 , 1086709141 , 1008427758 , 2079358852 , 3369242101 , 2378959285 , 4108050209 ) AND stats_players_topalias . SERVERID = 1 GROUP BY stats_aliases . PLAYERID ;
Copy
7
0.38 ms
SELECT stats_time . PLAYERID , sum (stats_time . TIMEPLAYED ) as TotalSeconds FROM stats_time WHERE stats_time . PLAYERID IN (1411893074 , 4279534630 , 682876912 , 4184764196 , 24882786 , 1420733202 , 4293707123 , 2601224506 , 516204237 , 1086709141 , 1008427758 , 2079358852 , 3369242101 , 2378959285 , 4108050209 ) GROUP BY stats_time . PLAYERID
SELECT stats_time . PLAYERID , sum (stats_time . TIMEPLAYED ) as TotalSeconds FROM stats_time WHERE stats_time . PLAYERID IN (1411893074 , 4279534630 , 682876912 , 4184764196 , 24882786 , 1420733202 , 4293707123 , 2601224506 , 516204237 , 1086709141 , 1008427758 , 2079358852 , 3369242101 , 2378959285 , 4108050209 ) GROUP BY stats_time . PLAYERID ;
Copy
8
0.13 ms
SELECT sum (stats_players . Kills ) / sum (stats_players . Deaths ) as MaxKillRatio FROM stats_players WHERE Kills > 25 AND stats_players . SERVERID = 1 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 AND stats_players . SERVERID = 1 GROUP BY stats_players . GUID ORDER BY MaxKillRatio DESC LIMIT 1 ;
Copy
9
0.08 ms
SELECT ID , Name FROM stats_servers ORDER BY ID
SELECT ID , Name FROM stats_servers ORDER BY ID ;
Copy
10
0.18 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
11
0.27 ms
SELECT stats_weapons . ID as WEAPONID , stats_weapons . INGAMENAME , stats_weapons . DisplayName as WeaponDisplayName , stats_weapons . WeaponType FROM stats_weapons INNER JOIN (stats_weapons_perserver ) ON (stats_weapons . ID = stats_weapons_perserver . WEAPONID ) WHERE stats_weapons_perserver . SERVERID = 1 GROUP BY stats_weapons . ID 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 INNER JOIN (stats_weapons_perserver ) ON (stats_weapons . ID = stats_weapons_perserver . WEAPONID ) WHERE stats_weapons_perserver . SERVERID = 1 GROUP BY stats_weapons . ID ORDER BY stats_weapons . WeaponType , stats_weapons . INGAMENAME ;
Copy
12
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
13
0.09 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
14
0.36 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
15
0.12 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