SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Les fondateurs d Azeroth' AND `server` = 'Krasus'
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 = 'Zirox' AND a.server = 'Krasus' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Zirox'
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` = 43 ORDER BY `talenttree` . `order` ASC
SELECT * FROM `roster_spellbook` WHERE `member_id` = '43' AND `spell_type` = 'Général' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '43' AND `spell_type` = 'Sacré' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '43' AND `spell_type` = 'Protection' ORDER BY `spell_name`;
SELECT * FROM `roster_spellbook` WHERE `member_id` = '43' AND `spell_type` = 'Vindicte' ORDER BY `spell_name`;