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` = 'Forge'
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 = 'Contrepoids en fer'
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 = 'Eperons en mithril'
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 = 'Corruptrice'
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 = 'Couteaux de murmure en gangracier'
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 = 'Fléchettes lourdes en bronze'
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 = 'Haches tourbillonnantes en acier'
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 = 'Lames en thorium enchanté'
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 = 'Bâtonnet d\'argent'
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 = 'Bâtonnet doré'
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 = 'Bâtonnet en vrai-argent'
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 = 'Passe-partout en argent'
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 = 'Passe-partout en or'
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 = 'Pierre de lest brute'
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 = 'Pierre de lest lourde'
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 = 'Pierre à aiguiser grossiè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 = 'Pierre à aiguiser lourde'
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 = 'Pointe de bouclier en fer'
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 = 'Silex à aiguiser 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 = 'Silex à aiguiser solide'
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 = 'Gardien de sauvegarde inférieure'
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 = 'Passe-partout en arcanite'
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 = 'Passe-partout en vrai-argent'
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 = 'Pierre de lest d\'adamantite'
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 = 'Pierre de lest dense'
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 = 'Pierre de lest gangrené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 = 'Pierre de lest grossiè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 = 'Pierre de lest solide'
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 = 'Pierre à aiguiser adamantine'
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 = 'Pierre à aiguiser brute'
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 = 'Pierre à aiguiser dense'
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 = 'Pierre à aiguiser gangré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 = 'Pierre à aiguiser solide'
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 = 'Rune de garde inférieure'
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 = 'Rune de garde supérieure'
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 = 'Silex à aiguiser grossier'
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 = 'Dague d\'acier luisante'
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 = 'Dague en acier luisant'
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 = 'Dague en adamantite'
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 = 'Dague en cuivre'
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 = 'Dague à manche de perles'
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 = 'Dague à perles'
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 = 'Grand couteau en bronze'
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 = 'Poignard mortel en bronze'
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 = 'Cylindre damasquiné en mithril'
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 = 'Bâtonnet en adamantite'
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 = 'Bâtonnet en arcanite'
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 = 'Bâtonnet en argent'
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 = 'Bâtonnet en gangrefer'
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 = 'Championne en vrai-argent'
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 = 'Claymore de forge-pierre'
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 = 'Claymore en cuivre'
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 = 'Epée d\'acier lunaire'
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 = 'Epée de guerre en bronze'
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 = 'Estramaçon en bronze'
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 = 'Estramaçon en gangrefer'
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 = 'Lame Coeur-de-lion'
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 = 'Lourde épée large en cuivre'
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 = 'Tigresse glaciale'
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 = 'Epée courte en bronze'
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 = 'Epée courte en cuivre'
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 = 'Epée courte en fer trempé'
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 = 'Garde du 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 = 'Lame fantôme'
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 = 'Lame légère de forge-terre'
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 = 'Rapière de forge-vent'
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 = 'Rapière en adamantite'
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 = 'Rapière éblouissante en mithril'
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 = 'Serpentine de jade'
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 = 'Croissant des ombres'
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 = 'Découpeuse en sombrefer'
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 = 'Fendoir en adamantite'
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 = 'Gigantesque hache en fer'
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 = 'Hache de guerre en bronze'
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 = 'Hache de guerre en cuivre'
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 = 'Hache de guerre lourde'
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 = 'Hache en bronze'
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 = 'Hache en cuivre'
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 = 'Hache lourde en mithril'
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 = 'Hache lumineuse bleue'
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 = 'Hache légère de forge-ciel'
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 = 'Hachette en gangrefer'
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 barbares en fer'
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 acier poli'
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 anneaux de cuivre'
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 bronze argenté'
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 grossières en bronze'
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 = 'Bracelets en cuivre'
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 fer émeraude'
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 gangrefer'
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 mithril'
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 dorées'
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 guillochés en bronze'
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 cuivre'
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 = 'Camail en gangrefer'
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 = 'Camail en mithril'
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 = 'Camail en écailles dorées'
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 barbare en fer'
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 anneaux de cuivre'
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 cuivre'
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 barbare en fer'
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 acier'
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 bronze argenté'
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 dorées'
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 grossière en bronze'
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 radieuse'
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 rayonnante en argent'
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 en fer'
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 bronze argenté'
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 écailles dorées'
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 grossières en bronze'
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 bronze argenté'
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 fer émeraude'
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 ornés en cuivre'
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 runiques en cuivre'
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 barbares en fer'
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 anneaux de gangrefer'
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 = 'Haubergeon grossier en cuivre'
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 = 'Haubert en fer émeraude'
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 fer émeraude'
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 guerre orques'
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 fer émeraude'
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 mithril'
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 dorées'
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 grossières en bronze'
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 radieuses'
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 = 'Lorica en cuivre'
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 anneaux de cuivre'
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 cuivre'
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 = 'Plastron runique en cuivre'
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 en anneaux de gangrefer'
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 = 'Destructeur en fer doré'
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 = 'Grand maillet en cuivre'
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 = 'Maillet en adamantite'
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 = 'Marteau de guerre en bronze'
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 = 'Pulvériseur en sombrefer'
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 = 'Solide maillet en fer'
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 = 'Grande masse noire'
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 = 'Le Briseur'
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 = 'Marteau en gangrefer'
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 = 'Marteau léger de forge-d\'ambre'
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 = 'Masse en bronze'
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 = 'Masse en cuivre'
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 = 'Masse lourde en bronze'
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 = 'Puissant marteau en fer'
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 = 'Silex à aiguiser brut'
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 = 'Silex à aiguiser dense'
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 thorium'
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 plaques de gangrefer'
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 thorium'
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 impériales en plaques'
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 lourdes en mithril'
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 ornées en mithril'
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 plaques d\'adamantite'
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 thorium'
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 impériaux en plaques'
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 plaie-des-flammes'
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 plaques de gangrefer'
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 thorium'
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 impériale en plaques'
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 adamantite'
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 gangrefer'
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 vrai-argent'
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 lourde en mithril'
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 ornée en mithril'
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 impériales en plaques'
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 lourdes en mithril'
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 ornées en mithril'
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 vrai-argent'
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 lourds en mithril'
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 plaques d\'adamantite'
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 plaques de gangrefer'
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 ornés en mithril'
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 = 'Harnois en sombrefer'
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 de sombrerune'
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 plaques d\'acier'
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 lourd en mithril'
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 orné en mithril'
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 plaques de gangrefer'
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 lourd en mithril'
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 orné en mithril'
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 = 'Boucle en fer'
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