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` = 'Ingénierie'
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 = 'Recette du carburant de fusée gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Attracteur de poissons aquadynamique'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Coq de combat gnome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Ecureuil mécanique'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Extracteur de granules Zappeur-Gazier'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Kit de moissonneur compact'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lance-filet automatique gnome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Leurre'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Leurre ouvragé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Leurre perfectionné'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Longue-vue orné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 = 'Lunette basique'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunette de précision'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunette de sniper'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunette 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 = 'Lunette en khorium'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunette standard'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Mortier portable 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 = 'Rayon mortel gnome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Rayon réducteur gnome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Robot Cogn\'Baff'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Robot réparateur 74A'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Tamis à sel'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Trousse de réparation mécanique'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 dure fabriqué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 = 'Balle gyroscopique 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 = 'Balle lourde fabriqué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 = 'Balle légère fabriqué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 = 'Balles perçantes 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 = 'Obus 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 = 'Obus 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 = 'Obus 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 = 'Serrure d\'entraînement'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Fumigène blanc'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Fumigène 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 = 'Fusée 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 = 'Fusée verte'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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-fusées extrêmes'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 prévention gnome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Clé plate'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Distributeur de bombes des gobelins'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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échiqueteur dimensionnel - Zone 52'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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éfibrillateur gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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éfibrillateur gobelin XL'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Fusil-dragon gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lance-roquettes gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 mortier : rechargé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Mortier gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Système d\'occultation gnome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Télécommande universelle gnome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Altérateur de 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 = 'Amorces d\'explosion 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 = 'Armature 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 = 'Batterie en khorium'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Batterie 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 = 'Bidule bourdonnant 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 = 'Caisse 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 = 'Contact 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 = 'Contrefiche 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 = 'Convertisseur d\'arcanite 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 = 'Câble avec fusible'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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éclencheur instable'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Etui 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 = 'Gyrochronatome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Micro-ajusteur gyromatique'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Modulateur 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 = 'Poignée de boulons 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 = 'Poignée de boulons 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 = 'Poudre d\'explosion basique'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Poudre d\'explosion 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 = 'Poudre d\'explosion 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 = 'Poudre d\'explosion majeure'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Poudre d\'explosion élémentaire'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Poudre noire 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 = 'Rouage 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 = 'Stabilisateur 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 = 'Structure 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 = 'Structure 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 = 'Tube en adamantite 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 = 'Tube 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 = 'Tube 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 = 'Tube 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 = 'Tube 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 = 'Bombe 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 = 'Bombe explosive'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bombe explosive 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 = 'Bombe grossière 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 = 'Charge de sapeur gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Dynamite Ev-Lan'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Dynamite Ev-Lan II'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Dynamite basique'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Dynamite 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 = 'Dynamite 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 = 'Dynamite 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 = 'Dynamite 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 = 'Grande bombe 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 = 'Grande bombe 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 = 'Grande bombe 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 charge d\'hydroglycérine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Grenade 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 = 'Grenade 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 = 'Grenade 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 = 'Grenades 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 = 'L\'Encore-Plus-Mastoc'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 Mastoc'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Mouton explosif'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 bombe 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 = 'Petite charge d\'hydroglycérine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Super-charge de sapeur'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 = 'Carabine de gros calibre 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 = 'Carabine 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 = 'Carabine 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 = 'Carabine 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 = 'Destructeur gyroscopique en khorium'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Espingole 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 = 'Fusil plaqué 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 = 'Mousquet 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 = 'Tromblon 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 = 'Tromblon mortel'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 mineur gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunettes vise-juste v2.0'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Boîte à outils 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-fusées gnomes'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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-fusées gobelines'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 parachute'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 chantier gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Coiffe de contrôle mental gnome'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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-fusée gobelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lentille verte'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunettes d\'amplification 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 = 'Lunettes de concentration extrê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 = 'Lunettes 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 = 'Lunettes de fortification des sorts'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunettes de maître ingénieur'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunettes de tigre volant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunettes 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 = 'Lunettes gnomes'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunettes roses'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lunettes teintées vertes'
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