SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'les inséparables' 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 = 'Ojoyauxluron' AND a.server = 'Sinstralis' AND a.guild_id = c.guild_id
SELECT `dateupdatedutc` FROM `roster_players` WHERE `name` = 'Ojoyauxluron'
SELECT * FROM `roster_players` WHERE `name` = 'Ojoyauxluron' AND `server` = 'Sinstralis'
SELECT * FROM `roster_pets` WHERE `member_id` = '7' order by `level` DESC
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Head'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Neck'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Shoulder'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Back'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Chest'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Shirt'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Tabard'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Wrist'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'MainHand'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'SecondaryHand'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Ranged'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Ammo'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Hands'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Waist'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Legs'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Feet'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Finger0'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Finger1'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Trinket0'
SELECT * FROM `roster_items` WHERE `member_id` = 7 AND `item_slot` = 'Trinket1'
SELECT * FROM `roster_players` WHERE `name` = 'Ojoyauxluron' AND `server` = 'Sinstralis'
SELECT * FROM `roster_pets` WHERE `member_id` = '7' order by `level` DESC
SELECT * FROM `roster_reputation` WHERE `member_id` = '7' ORDER BY `faction` ASC
SELECT * FROM `roster_skills` WHERE `member_id` = '7' AND `skill_type` = 'Compétences de Classe'
SELECT * FROM `roster_skills` WHERE `member_id` = '7' AND `skill_type` = 'Métiers'
SELECT * FROM `roster_skills` WHERE `member_id` = '7' AND `skill_type` = 'Compétences secondaires'
SELECT * FROM `roster_skills` WHERE `member_id` = '7' AND `skill_type` = 'Compétences d’armes'
SELECT * FROM `roster_skills` WHERE `member_id` = '7' AND `skill_type` = 'Armures portables'
SELECT * FROM `roster_skills` WHERE `member_id` = '7' AND `skill_type` = 'Langues'
SELECT * FROM `roster_talenttree` WHERE `member_id` = '7' ORDER BY `order`;
SELECT i.item_tooltip, i.item_name, i.item_color, p.parry, p.dodge, p.block, p.crit, p.mitigation, p.clientLocale
FROM `roster_items` i, `roster_players` p
WHERE i.item_parent = 'equip'
and i.member_id = p.member_id
and p.name = 'Ojoyauxluron'
and p.server = 'Sinstralis'