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'
SHOW TABLES LIKE 'roster_addon_madeby_config'
SELECT `config_name`, `config_value` FROM `roster_addon_madeby_config` ORDER BY `id` ASC;
SELECT config_name FROM roster_addon_madeby_config
WHERE config_type = 'recipe'
AND config_value = '1'
ORDER BY config_name
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