|
||||||||||||||||||||
- Amélioration d'objet - Artisanat - Autre - Carquois - Consommables - Conteneur - Cuir - Divers - Giberne - Mailles - Sac d'artisan du cuir - Sac de mineur - Sac de travail du cuir - Tissu - |
Amélioration d'objet | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Artisanat | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Autre | |||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||
Carquois | |||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||||||||||
Consommables | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Conteneur | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||
Cuir | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Divers | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||
Giberne | |||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||||||||||
Mailles | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sac d'artisan du cuir | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||
Sac de mineur | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||
Sac de travail du cuir | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||
Tissu | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Allez à la Configuration Objets d'artisanat | ||
SQL Queries | ||
---|---|---|
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC; SELECT * FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` = 'Dalaran' 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` = 'Travail du cuir' 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 = 'Armure de jambe en cuir-fourchu' 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 = 'Armure de jambe en peau de cobra' 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 = 'Renfort d\'armure de la Nature.' 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 = 'Renfort d\'armure de redresseur de torts' 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 = 'Renfort d\'armure des Arcanes' 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 = 'Renfort d\'armure du Magma' 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 = 'Renfort d\'armure en cuir granuleux lourd' 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 = 'Renforts de gants' 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 = 'Cuir granuleux' 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 = 'Cuir léger' 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 = 'Cuir moyen' 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 = 'Cuir robuste' 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 = 'Cuir épais' 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 = 'Peau lourde traitée' 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 = 'Peau légère traitée' 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 = 'Peau moyenne traitée' 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 = 'Peau robuste traitée' 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 = 'Peau épaisse traitée' 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 = 'Tambours de bataille' 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 = 'Tambours de guerre' 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 = 'Tambours de restauration' 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 = 'Tambours de vitesse' 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 = 'Carquois de tir rapide' 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 = 'Carquois des mille plumes' 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 = 'Carquois en cuir granuleux lourd' 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 = 'Carquois en cuir léger' 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 = 'Carquois lourd' 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 = 'Balle en cuir lourd' 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 = 'Renfort d\'armure granuleux' 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 = 'Renfort d\'armure lourd' 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 = 'Renfort d\'armure léger' 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 = 'Renfort d\'armure moyen' 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 = 'Renfort d\'armure robuste' 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 = 'Renfort d\'armure épais' 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 = 'Sac en peau de kodo' 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 = 'Armure corrompue en cuir' 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 = 'Armure de dragonnet vert' 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 = 'Armure en cuir mat' 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 = 'Armure en cuir raffermi' 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 = 'Armure runique en cuir' 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 = 'Armure tempétueuse' 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 = 'Armure épaisse de murloc' 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 = 'Bandeau corrompu en cuir' 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 = 'Bandeau de la nuit' 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 = 'Bandeau runique en cuir' 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 = 'Bottes chimériques' 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 = 'Bottes de la nuit' 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 = 'Bottes de rapidité' 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 = 'Bottes draeniques sauvages' 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 = 'Bottes draeniques épaisses' 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 = 'Bottes en cuir cousu main' 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 = 'Bottes en cuir estampé' 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 = 'Bottes noires en cuir' 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 = 'Bottes élégantes en cuir' 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 = 'Brassards barbares' 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 = 'Brassards corrompus en cuir' 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 = 'Brassards de dragonnet vert' 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 = 'Brassards de gardien en cuir' 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 = 'Brassards en cuir cousu main' 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 = 'Brassards en cuir léger' 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 = 'Brassards en écailles de murloc' 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 = 'Brassards mats' 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 = 'Brassards runiques en cuir' 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 = 'Brassards verts en cuir' 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 = 'Casque de feu' 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 = 'Casque en cuir fauve' 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 = 'Ceinture corrompue en cuir' 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 = 'Ceinture d\'homme des collines' 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 = 'Ceinture de la ronceraie' 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 = 'Ceinture en cuir clouté de gemmes' 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 = 'Ceinture en cuir cousu main' 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 = 'Ceinture en écailles de déviant' 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 = 'Ceinture en écailles de murloc' 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 = 'Ceinture mate' 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 = 'Ceinture noire en cuir' 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 = 'Ceinture runique en cuir' 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 = 'Ceinture verte en cuir' 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 = 'Ceinture élégante en cuir' 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 = 'Cuir granuleux lourd' 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 = 'Cuir lourd' 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 = 'Epaulières barbares' 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 = 'Epaulières d\'homme des collines' 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 = 'Epaulières de la nuit' 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 = 'Epaulières en cuir fauve' 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 = 'Epaulières en cuir sauvage' 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 = 'Epaulières en plumacier' 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 = 'Epaulières runiques en cuir' 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 = 'Epaulières terrestres en cuir' 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 = 'Epaulières vivantes' 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 = 'Gantelets corrompus en cuir' 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 = 'Gantelets de la mer' 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 = 'Gantelets diablosaures' 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 = 'Gantelets runique en cuir' 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 = 'Gants chimériques' 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 = 'Gants d\'agilité en cuir' 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 = 'Gants d\'homme des collines en cuir' 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 = 'Gants de fabricant d\'arcs' 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 = 'Gants de fléchier' 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 = 'Gants de gardien' 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 = 'Gants draeniques sauvages' 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 = 'Gants draeniques épais' 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 = 'Gants du Grandpère' 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 = 'Gants en cuir estampé' 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 = 'Gants en cuir raffermi' 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 = 'Gants en peau d\'ombre' 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 = 'Gants en écailles de déviant' 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 = 'Gants noirs en cuir' 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 = 'Gants tempétueux' 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 = 'Gants élégants en cuir' 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 = 'Gilet chimérique' 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 = 'Gilet d\'homme des collines en cuir' 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 = 'Gilet draenique sauvage' 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 = 'Gilet draenique épais' 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 = 'Gilet en cuir cousu main' 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 = 'Gilet en cuir estampé' 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 = 'Gilet en cuir fauve' 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 = 'Harnais barbare' 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 = 'Harnais de l\'ours de guerre' 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 = 'Harnais en peau de raptor' 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 = 'Haut-de-chausses de l\'ours de guerre' 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 = 'Jambières barbares' 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 = 'Jambières de sabre-de-givre' 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 = 'Jambières diablosaures' 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 = 'Jambières draeniques sauvages' 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 = 'Jambières vivantes' 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 = 'Jambières volcaniques' 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 = 'Pantalon corrompu en cuir' 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 = 'Pantalon de gardien' 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 = 'Pantalon de la nuit' 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 = 'Pantalon draenique épais' 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 = 'Pantalon en cuir cousu main' 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 = 'Pantalon en cuir estampé' 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 = 'Pantalon en cuir léger' 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 = 'Pantalon noir en cuir' 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 = 'Pantalon runique en cuir' 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 = 'Pantalon tempétueux' 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 = 'Pantalon élégant en cuir' 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 = 'Robe du grand vaudou' 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 = 'Tunique de la nuit' 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 = 'Tunique noire en cuir' 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 = 'Tunique élégante en cuir' 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 = 'Cravache d\'équitation' 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 = 'Giberne en cuir granuleux lourd' 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 = 'Giberne en cuir lourd' 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 = 'Giberne en cuir épais' 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 = 'Giberne en écailles du 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 = 'Petite giberne en cuir' 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 = 'Bottes armées du scorpide' 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 = 'Bottes de la Furie du 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 = 'Bottes draeniques en écailles' 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 = 'Bottes en flamécaille' 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 = 'Bottes en gangrécailles' 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 = 'Brassards armés du scorpide' 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 = 'Brassards de crache-feu' 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 = 'Brassards de traqueur gangrené' 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 = 'Brassards de traqueuse des sables' 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 = 'Brassards en écailles de scorpide épaisses' 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 = 'Brassards en écailles de tortue' 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 = 'Broigne draenique' 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 = 'Casque armé du scorpide' 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 = 'Casque en écailles de tortue' 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 = 'Ceinture de la Furie du 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 = 'Ceinture de traqueur gangrené' 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 = 'Ceinture en flamécaille' 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 = 'Ceinture en écailles de scorpide épaisses' 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 = 'Cuirasse armée du scorpide' 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 = 'Cuirasse de traqueur gangrené' 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 = 'Cuirasse dorée de frappe de dragon' 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 = 'Cuirasse en gangrécailles' 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 = 'Cuirasse en écailles de dragon' 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 = 'Cuirasse en écailles de dragon bleu' 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 = 'Cuirasse en écailles de dragon vert' 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 = 'Cuirasse en écailles de tortue' 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 = 'Epaulières armées du scorpide' 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 = 'Gantelets de crache-feu' 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 = 'Gantelets de traqueuse des sables' 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 = 'Gantelets en écailles de dragon' 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 = 'Gantelets en écailles de dragon vert' 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 = 'Gantelets en écailles de scorpide épaisses' 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 = 'Gants armés du scorpide' 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 = 'Gants draeniques en écailles' 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 = 'Gants en gangrécailles' 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 = 'Gants en écailles de tortue' 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 = 'Heaume en écailles de scorpide épaisses' 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 = 'Jambières armées du scorpide' 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 = 'Jambières de frappe de dragon' 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 = 'Jambières de la Furie du 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 = 'Jambières en écailles de dragon bleu' 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 = 'Jambières en écailles de dragon noir' 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 = 'Jambières en écailles de dragon vert' 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 = 'Jambières en écailles de scorpide épaisses' 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 = 'Jambières en écailles de tortue' 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 = 'Pantalon draenique en écailles' 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 = 'Pantalon en gangrécailles' 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 = 'Sacoche d\'artisan du cuir' 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 = 'Sac de mineur renforcé' 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 = 'Sacoche de travailleur du cuir' 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 = 'Bottes d\'hiver' 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 = 'Cape d\'homme des collines' 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 = 'Cape de gardien' 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 = 'Cape de givre en cuir' 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 = 'Cape du grand vaudou' 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 = 'Cape en cuir cousu main' 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 = 'Cape en cuir estampé' 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 = 'Cape en cuir sauvage' 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 = 'Cape en écailles de déviant' 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 = 'Cape noire en cuir' 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 = 'Cape élégante en cuir' ORDER by m.name SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` ='Dalaran' SELECT IF(`note` LIKE '%reroll%',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 |
||