SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Chevaliers' AND `server` = 'Sinstralis'
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 = 'Gill' AND a.server = 'Sinstralis' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Gill'
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` = 42 ORDER BY `talenttree` . `order` ASC
SELECT * FROM `roster_spellbook` WHERE `member_id` = '42' AND `spell_type` = 'Général' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '42' AND `spell_type` = 'Affliction' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '42' AND `spell_type` = 'Démonologie' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '42' AND `spell_type` = 'Destruction' ORDER BY `spell_name`;