SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` = 'Dalaran'
SELECT * FROM roster_events
SELECT * FROM `roster_events` WHERE eventid="2"
SELECT * FROM `roster_events` WHERE eventid="2"
SELECT s.name, s.note, m.class, m.guild, m.level FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON s.name = m.name WHERE s.status = "Y" AND s.eventid="2" ORDER BY s.place ASC
SELECT s.name, s.note, m.class, m.guild, m.level FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON s.name = m.name WHERE s.status = "S" AND s.eventid="2" ORDER BY s.place ASC
SELECT s.name, s.note, m.class, m.guild, m.level FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON s.name = m.name WHERE s.status = "R" AND s.eventid="2" ORDER BY s.place ASC
SELECT * FROM `roster_event_limits` WHERE eventid = 2 ORDER BY class ASC
SELECT s.name FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON m.name = s.name WHERE m.class = "Druid" AND eventid = 2
SELECT s.name FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON m.name = s.name WHERE m.class = "Hunter" AND eventid = 2
SELECT s.name FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON m.name = s.name WHERE m.class = "Mage" AND eventid = 2
SELECT s.name FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON m.name = s.name WHERE m.class = "Priest" AND eventid = 2
SELECT s.name FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON m.name = s.name WHERE m.class = "Rogue" AND eventid = 2
SELECT s.name FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON m.name = s.name WHERE m.class = "Shaman" AND eventid = 2
SELECT s.name FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON m.name = s.name WHERE m.class = "Warlock" AND eventid = 2
SELECT s.name FROM `roster_event_subscribers` AS s LEFT JOIN `roster_event_members` AS m ON m.name = s.name WHERE m.class = "Warrior" AND eventid = 2
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` ='Dalaran'
SELECT IF(`note` LIKE '%reroll%',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