SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Nox Oriens' AND `server` = 'Lightninghoof'
SELECT a.*, b.*, c.guild_name FROM `roster_players` a, `roster_members` b, `roster_guild` c WHERE a.member_id = b.member_id AND a.name = 'Shadowsfire' AND a.server = 'Lightninghoof' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Shadowsfire'
SELECT * FROM `roster_recipes` where `member_id` = '34' ORDER BY `skill_name` ASC , `difficulty` DESC , `recipe_type` ASC , `recipe_name` ASC
SELECT `skill_name` FROM `roster_recipes` WHERE `member_id` = '34' GROUP BY `skill_name` ORDER BY `skill_name`