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` = 'Joaillerie'
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 = 'Coup de poing lourd 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 = 'Adamantite mercurienne'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Fil de cuivre délicat'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Filigrane 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 = 'Monture 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 = 'Monture 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 = 'Etoile d\'Elune étincelante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 lune azur orageuse'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 lune azur satiné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 lune azur 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 de lune azur étincelante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Statue en pierre 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 = 'Statue en pierre 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 = 'Statue en pierre 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 = 'Statue en pierre 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 = 'Statue en pierre 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 = 'Amulette de la lune'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau ciselé 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 = 'Anneau d\'argent élégant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau d\'assaut'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau d\'opale simple'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau d\'émeraude du 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 = 'Anneau de citrine de soin accéléré'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau de citrine flamboyant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau de commandant 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 = 'Anneau de draénite doré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 = 'Anneau de fils 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 = 'Anneau de malachite damasquiné'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau de perle simple'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau de pierre de lune azur'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau de pierre de lune pernicieux'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau de protection contre les 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 = 'Anneau de sang 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 = 'Anneau de soin 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 = 'Anneau des ombres amères'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau des ombres crépusculaires'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau doré de puissance'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau doré du 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 = 'Anneau du pouvoir 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 = 'Anneau délicat en éternium'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau en cuivre tressé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Anneau solide 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 = 'Anneau épais 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 = 'Anneau épais 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 = 'Anneau épais 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 = 'Anneau épais 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 = 'Bague d\'obscurité'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bague d\'oeil de tigre'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bague de destruction rouge'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bague de force 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 = 'Bague de jade 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 = 'Bague du feu naturel'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bague en perles brillantes'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bague luminescente 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 = 'Bague à diamant de focalisation'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bague émaillée 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 = 'Chaîne en éternium tressé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Chevalière d\'aigue-marine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Chevalière de saphir'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Collier brillant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Collier d\'oeil de tigre orné'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Collier d\'opale d\'impact'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Collier de bataille épais 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 = 'Collier de la tour de diamant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Collier des profondeurs'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Collier épais 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 = 'Collier épais 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 = 'Couronne d\'âmelune'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Figurine - Chouette 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 = 'Figurine - Chouette de talasite'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Figurine - Crabe 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 = 'Figurine - Panthère d\'oeil de 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 = 'Figurine - Panthère de perle 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 = 'L\'oeil 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 = 'La Perle 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 = 'La garde d\'aigue-marine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Pendentif d\'aigue-marine du guerrier'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Pendentif d\'émeraude vivante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Pendentif de jade d\'explosion'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Pendentif de malachite'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Pendentif de rubis 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 = 'Pendentif de saphir de la nuit 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 = 'Pendentif du bouclier d\'agate'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Torque 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 = 'Torque 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 = 'Draénite dorée bombé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 = 'Draénite dorée brillante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Draénite dorée lisse'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Draénite dorée resplendissante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Draénite dorée rigide'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 d\'aube rigide'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Diamant brûleciel de mystè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 = 'Diamant brûleciel 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 = 'Diamant tonneterre de perspicacité'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Spessarite de flamme intaillé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 = 'Spessarite de flamme 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 = 'Spessarite de flamme lumineuse'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Spessarite de flamme toute-puissante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Topaze noble intaillé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 = 'Topaze noble 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 = 'Topaze noble lumineuse'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Grenat sanguin délicat'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Grenat sanguin soutenu'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Grenat sanguin éclatant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Larme de grenat sanguin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Rubis vivant subtil'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Olivine dentelé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 = 'Olivine durcie'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Olivine 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 = 'Talasite durcie'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Talasite éblouissante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Draénite ombreuse changeante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Draénite ombreuse luminescente'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Draénite ombreuse royale'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Draénite ombreuse souveraine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Oeil de nuit infusé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Perle d\'ombre purifié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 = 'Perle de jaggale purifiée'
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