| 142 |
0.0007 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
| 488 |
0.0006 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
| 405 |
0.0006 |
SELECT guild.* FROM `roster_guild` guild WHERE `guild_id` = "1"; |
| 1021 |
0.0005 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '3' ORDER BY `id` ASC; |
| 1021 |
0.0006 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '3' ORDER BY `id` ASC; |
| 36 |
0.0016 |
SELECT `name`, `lifetimeRankName` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `lifetimeHighestRank`DESC, `lifetimeHK` DESC LIMIT 0 , 1 |
| 53 |
0.0003 |
SELECT `name`, `lifetimeHK` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `lifetimeHK` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1 |
| 70 |
0.0003 |
SELECT `name`, `honorpoints` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `honorpoints` DESC LIMIT 0 , 1 |
| 87 |
0.0003 |
SELECT `name`, `arenapoints` FROM `roster_players` WHERE `guild_id` = '1' ORDER BY `arenapoints` DESC LIMIT 0 , 1 |
| 356 |
0.0577 |
SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`level`, `members`.`zone`, (UNIX_TIMESTAMP( `members`.`last_online`)*1000+-18000000) AS 'last_online_stamp', DATE_FORMAT( DATE_ADD(`members`.`last_online`, INTERVAL -5 HOUR ), '%a %b %D, %l:%i %p' ) AS 'last_online', `members`.`note`, IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', `members`.`guild_title`, `alts`.`main_id`, `players`.`server`, `players`.`race`, `players`.`sex`, `players`.`exp`, `players`.`clientLocale`, `players`.`sessionHK`, `players`.`sessionCP`, `players`.`yesterdayHK`, `players`.`yesterdayContribution`, `players`.`lifetimeHK`, `players`.`lifetimeRankName`, `players`.`lifetimeHighestRank`, IF( `players`.`lifetimeHighestRank` IS NULL OR `players`.`lifetimeHighestRank` = '0', 1, 0 ) AS 'risnull', `players`.`honorpoints`, `players`.`arenapoints`, GROUP_CONCAT( DISTINCT CONCAT( `talenttable`.`tree` , '|', `talenttable`.`pointsspent` , '|', `talenttable`.`background` ) ORDER BY `talenttable`.`order`) AS 'talents' FROM `roster_members` AS members INNER JOIN `roster_players` AS players ON `members`.`member_id` = `players`.`member_id` LEFT JOIN `roster_addons_memberslist_alts` AS alts ON `members`.`member_id` = `alts`.`member_id` LEFT JOIN `roster_talenttree` AS talenttable ON `members`.`member_id` = `talenttable`.`member_id` WHERE `members`.`guild_id` = "1" GROUP BY `members`.`member_id` ORDER BY IF(`members`.`member_id` = `alts`.`member_id`,1,0), `members`.`level` DESC, `members`.`name` ASC; |
| 166 |
0.0004 |
SELECT `guild_name`, CONCAT(`region`,'-',`server`), `guild_id` FROM `roster_guild` ORDER BY `region` ASC, `server` ASC, `guild_name` ASC; |
| 414 |
0.0004 |
SELECT count(`member_id`) AS `amount`, IF(`guild_title` LIKE '%alt%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 30 AND `guild_id` = '1' GROUP BY isalt, label; |
| 608 |
0.0006 |
SELECT `mb`.*, `a`.`basename` FROM `roster_menu_button` AS mb LEFT JOIN `roster_addon` AS a ON `mb`.`addon_id` = `a`.`addon_id` WHERE `a`.`addon_id` IS NULL OR `a`.`active` = 1; |
| 625 |
0.0004 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`; |
|
Honor System Stats 
Close all
Master Sergeant
Knight
Corporal
Private
