| 146 |
0.0004 |
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; |
| 492 |
0.0002 |
SELECT * FROM `roster_addon` ORDER BY `basename`; |
| 353 |
0.001 |
SELECT guild.*, members.*, players.*, DATE_FORMAT( DATE_ADD(`players`.`dateupdatedutc`, INTERVAL 1 HOUR ), "%a %b %D, %l:%i %p" ) 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` = "124"; |
| 212 |
0.0002 |
SELECT `name`, `member_id` FROM `roster_players` WHERE `guild_id` = '' ORDER BY `name` ASC; |
| 423 |
0.0003 |
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` = '' GROUP BY isalt, label; |
| 423 |
0.0002 |
SELECT count(`member_id`) AS `amount`, IF(`guild_title` LIKE '%Alt%',1,0) AS isalt, `classid` AS label FROM `roster_members` WHERE `level` >= 60 AND `guild_id` = '' GROUP BY isalt, label; |
| 603 |
0.0021 |
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; |
| 620 |
0.0003 |
SELECT * FROM `roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`; |
|