|
||||||||||||||||||||
Best Win/Level-Diff Average | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||||
SQL Queries | ||
---|---|---|
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; SELECT * FROM `roster_guild` WHERE `guild_name` = 'Yggdrasyll' AND `server` = 'Sinstralis' SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Yggdrasyll' AND `server` ='Sinstralis' SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS levelgroup, COUNT(`level`) AS amount, SUM(`level`) AS sum FROM `roster_members` GROUP BY isalt, levelgroup ORDER BY isalt ASC, levelgroup DESC SELECT pvp3.member_id, members.name as gn, AVG(pvp3.`leveldiff`) as ave, COUNT(pvp3.member_id) as countg FROM `roster_pvp2` pvp3 LEFT JOIN `roster_members` members ON members.member_id = pvp3.member_id WHERE win = '1' AND enemy = '1' GROUP BY pvp3.member_id ORDER BY ave DESC |
||