142 |
0.0151 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
488 |
0.013 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
349 |
0.0642 |
SELECT guild.*, members.*, players.*, DATE_FORMAT( DATE_ADD(`players`.`dateupdatedutc`, INTERVAL 0 HOUR ), "%d/%m/%Y %H:%i:%s" ) AS "update_format" FROM `roster_players` players LEFT JOIN `roster_members` members ON `players`.`member_id` = `members`.`member_id` LEFT JOIN `roster_guild` guild ON `players`.`guild_id` = `guild`.`guild_id` WHERE `players`.`member_id` = "172"; |
1021 |
0.0235 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '2' ORDER BY `id` ASC; |
1021 |
0.0005 |
SELECT `config_name`, `config_value` FROM `roster_addon_config` WHERE `addon_id` = '2' ORDER BY `id` ASC; |
356 |
0.0007 |
SELECT `guild`.`guild_name`, `guild`.`guild_id`, `guild`.`faction`, `guild`.`factionEn`, `guild`.`guild_num_members`, `guild`.`guild_num_accounts`, `guild`.`guild_motd` FROM `roster_guild` AS guild WHERE `guild`.`server` = "Khaz Modan" ORDER BY `guild`.`guild_name` ASC; |
121 |
0.0008 |
SELECT DISTINCT `server`, `region` FROM `roster_guild` UNION SELECT DISTINCT `server`, `region` FROM `roster_players` ORDER BY `server` ASC; |
414 |
0.0097 |
SELECT count(`member_id`) AS `amount`, IF(`guild_title` LIKE '%Reroll%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `roster_members` WHERE `level` >= 1 GROUP BY isalt, label; |
608 |
0.0141 |
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.0154 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild','char') ORDER BY `config_id`; |