SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'La Ménagerie' AND `server` = 'Sargeras'
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 = 'Filunar' AND a.server = 'Sargeras' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Filunar'
SELECT `spelltree`.*, `talenttree`.`order` FROM `roster_spellbooktree` AS spelltree LEFT JOIN `roster_talenttree` AS talenttree ON `spelltree`.`member_id` = `talenttree`.`member_id` AND `spelltree`.`spell_type` = `talenttree`.`tree` WHERE `spelltree` . `member_id` = 27 ORDER BY `talenttree` . `order` ASC
SELECT * FROM `roster_spellbook` WHERE `member_id` = '27' AND `spell_type` = 'Général' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '27' AND `spell_type` = 'Arcane' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '27' AND `spell_type` = 'Feu' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '27' AND `spell_type` = 'Givre' ORDER BY `spell_name`;