| 1083 |
0 |
SELECT `config_name`, `config_value` FROM `wow_roster_addon_config` WHERE `addon_id` = '7' ORDER BY `id` ASC; |
| 1083 |
0.008 |
SELECT `config_name`, `config_value` FROM `wow_roster_addon_config` WHERE `addon_id` = '7' ORDER BY `id` ASC; |
| 41 |
0 |
SELECT `name`, `lifetimeRankName` FROM `wow_roster_players` WHERE `guild_id` = '1' ORDER BY `lifetimeHighestRank`DESC, `lifetimeHK` DESC LIMIT 0 , 1 |
| 70 |
0 |
SELECT `name`, `lifetimeHK` FROM `wow_roster_players` WHERE `guild_id` = '1' ORDER BY `lifetimeHK` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1 |
| 92 |
0.004 |
SELECT `name`, `honorpoints` FROM `wow_roster_players` WHERE `guild_id` = '1' ORDER BY `honorpoints` DESC LIMIT 0 , 1 |
| 114 |
0 |
SELECT `name`, `arenapoints` FROM `wow_roster_players` WHERE `guild_id` = '1' ORDER BY `arenapoints` DESC LIMIT 0 , 1 |
| 45 |
0.128 |
SELECT `pvp`.`guild`, COUNT(`pvp`.`guild`) AS countg FROM `wow_roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `wow_roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`guild` ORDER BY countg DESC |
| 80 |
0.004 |
SELECT `pvp`.`guild`, COUNT(`pvp`.`guild`) AS countg FROM `wow_roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `wow_roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '0' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`guild` ORDER BY countg DESC |
| 115 |
0.008 |
SELECT `pvp`.`name`, COUNT(`pvp`.`name`) AS countg FROM `wow_roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `wow_roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`guild` != '' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`name` ORDER BY countg DESC |
| 142 |
0.004 |
SELECT `pvp`.`name`, COUNT(`pvp`.`name`) AS countg FROM `wow_roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `wow_roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '0' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`name` ORDER BY countg DESC |
| 169 |
0.004 |
SELECT `pvp`.`member_id`, `members`.`name` AS gn, COUNT(`pvp`.`member_id`) AS countg FROM `wow_roster_addons_pvplog_pvp2` pvp LEFT JOIN `wow_roster_members` members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`member_id` ORDER BY countg DESC; |
| 197 |
0 |
SELECT `pvp`.`member_id`, `members`.`name` AS gn, COUNT(`pvp`.`member_id`) AS countg FROM `wow_roster_addons_pvplog_pvp2` pvp LEFT JOIN `wow_roster_members` members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '0' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`member_id` ORDER BY countg DESC; |
| 226 |
0 |
SELECT `pvp`.`member_id`, `members`.`name` AS gn, AVG(`pvp`.`leveldiff`) AS ave, COUNT(`pvp`.`member_id`) AS countg FROM `wow_roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `wow_roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '1' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`member_id` ORDER BY ave DESC |
| 262 |
0 |
SELECT `pvp`.`member_id`, `members`.`name` AS gn, AVG(`pvp`.`leveldiff`) AS ave, COUNT(`pvp`.`member_id`) AS countg FROM `wow_roster_addons_pvplog_pvp2` AS pvp LEFT JOIN `wow_roster_members` AS members ON `members`.`member_id` = `pvp`.`member_id` WHERE `members`.`guild_id` = '1' AND `pvp`.`win` = '0' AND `pvp`.`enemy` = '1' GROUP BY `pvp`.`member_id` ORDER BY ave DESC |
| 413 |
0.18 |
SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`level`, `members`.`zone`, `members`.`online`, `members`.`last_online`, UNIX_TIMESTAMP(`members`.`last_online`) AS 'last_online_stamp', DATE_FORMAT( DATE_ADD(`members`.`last_online`, INTERVAL 0 HOUR ), '%d/%m/%Y %H:%i:%s' ) AS 'last_online_format', `members`.`note`, `members`.`guild_title`, `alts`.`main_id`, `guild`.`update_time`, IF( `members`.`note` IS NULL OR `members`.`note` = '', 1, 0 ) AS 'nisnull', `members`.`officer_note`, IF( `members`.`officer_note` IS NULL OR `members`.`officer_note` = '', 1, 0 ) AS 'onisnull', `members`.`guild_rank`, `players`.`server`, `players`.`race`, `players`.`sex`, `players`.`exp`, `players`.`clientLocale`, `players`.`lifetimeRankName`, `players`.`lifetimeHighestRank`, IF( `players`.`lifetimeHighestRank` IS NULL OR `players`.`lifetimeHighestRank` = '0', 1, 0 ) AS 'risnull', `players`.`hearth`, IF( `players`.`hearth` IS NULL OR `players`.`hearth` = '', 1, 0 ) AS 'hisnull', UNIX_TIMESTAMP( `players`.`dateupdatedutc`) AS 'last_update_stamp', DATE_FORMAT( DATE_ADD(`players`.`dateupdatedutc`, INTERVAL 0 HOUR ), '%d/%m/%Y %H:%i:%s' ) AS 'last_update_format', IF( `players`.`dateupdatedutc` IS NULL OR `players`.`dateupdatedutc` = '', 1, 0 ) AS 'luisnull', `proftable`.`professions`, `talenttable`.`talents` FROM `wow_roster_members` AS members LEFT JOIN `wow_roster_players` AS players ON `members`.`member_id` = `players`.`member_id` LEFT JOIN (SELECT `member_id` , GROUP_CONCAT( CONCAT( `skill_name` , '|', `skill_level` ) ORDER BY `skill_order`) AS 'professions' FROM `wow_roster_skills` GROUP BY `member_id`) AS proftable ON `members`.`member_id` = `proftable`.`member_id` LEFT JOIN (SELECT `member_id` , GROUP_CONCAT( CONCAT( `tree` , '|', `pointsspent` , '|', `background` ) ORDER BY `order`) AS 'talents' FROM `wow_roster_talenttree` GROUP BY `member_id`) AS talenttable ON `members`.`member_id` = `talenttable`.`member_id` LEFT JOIN `wow_roster_addons_memberslist_alts` AS alts ON `members`.`member_id` = `alts`.`member_id` LEFT JOIN `wow_roster_guild` AS guild ON `members`.`guild_id` = `guild`.`guild_id` WHERE `members`.`guild_id` = "1" ORDER BY IF(`members`.`member_id` = `alts`.`member_id`,1,0), `members`.`level` DESC, `members`.`name` ASC; |
| 166 |
0.024 |
SELECT `guild_name`, CONCAT(`region`,'-',`server`), `guild_id` FROM `wow_roster_guild` ORDER BY `region` ASC, `server` ASC, `guild_name` ASC; |
| 414 |
0.032 |
SELECT count(`member_id`) AS `amount`, IF(`note` LIKE '%reroll%',1,0) AS 'isalt', FLOOR(`level`/10) AS label FROM `wow_roster_members` WHERE `level` >= 30 AND `guild_id` = '1' GROUP BY isalt, label; |
| 608 |
0.04 |
SELECT `mb`.*, `a`.`basename` FROM `wow_roster_menu_button` AS mb LEFT JOIN `wow_roster_addon` AS a ON `mb`.`addon_id` = `a`.`addon_id` WHERE `a`.`addon_id` IS NULL OR `a`.`active` = 1; |
| 625 |
0.04 |
SELECT * FROM `wow_roster_menu` WHERE `section` IN ('util','realm','guild') ORDER BY `config_id`; |
| 36 |
0.32 |
SELECT `member_id`, `name` FROM `wow_roster_members` ORDER BY `name`; |
| 36 |
0.244 |
SELECT `zone`, `quest_name` FROM `wow_roster_quests` ORDER BY `quest_name`; |
|
Ordre de tri et filtres
Ordre de tri et filtres
![[]](img/no_note.gif)
![[]](img/note.gif)
