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'
SHOW TABLES LIKE 'roster_addon_madeby_config'
SELECT `config_name`, `config_value` FROM `roster_addon_madeby_config` ORDER BY `id` ASC;
SELECT config_name FROM roster_addon_madeby_config
WHERE config_type = 'recipe'
AND config_value = '1'
ORDER BY config_name
SELECT distinct recipe_name, recipe_tooltip, recipe_type, item_color, skill_name, reagents, recipe_texture, level, 1 difficulty
FROM `roster_recipes`
WHERE `skill_name` = 'Premiers soins'
GROUP BY recipe_name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anti-venin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anti-venin puissant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage en laine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage en lin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage en soie'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage en tisse-mage'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage en tisse-néant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage en étoffe runique'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage épais en laine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage épais en lin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage épais en soie'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage épais en tisse-mage'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage épais en tisse-néant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bandage épais en étoffe runique'
ORDER by m.name
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'La Ménagerie' AND `server` ='Sargeras'
SELECT IF(`note` LIKE '%%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC