SELECT `config_name`, `config_value` FROM `roster2_config` ORDER BY `id` ASC;
SELECT * FROM `roster2_guild` WHERE `guild_name` = 'Imperial Defenders' AND `server` = 'Terenas'
SELECT * FROM roster2_events
SELECT * FROM `roster2_events` WHERE type != "Birth" AND type !="Meet" ORDER BY date ASC
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 7
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 7
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 8
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 8
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 4
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 4
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 10
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 10
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 5
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 5
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 11
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 11
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 9
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 9
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 2
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 2
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 3
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 3
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 6
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 6
SELECT name FROM `roster2_event_subscribers` WHERE status = "Y" AND eventid = 1
SELECT name FROM `roster2_event_subscribers` WHERE status != "Y" AND eventid = 1
SELECT * FROM `roster2_events` WHERE type = "Meet" ORDER BY date ASC
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster2_guild` WHERE `guild_name` = 'Imperial Defenders' AND `server` ='Terenas'
SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster2_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC