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` = 'Cuisine'
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 = 'Aile de busard grillé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 = 'Aile de chauve-souris croustillante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Biscuit au pain d\'épices'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bisque de tortue apaisante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bouchées à la chauve-souris'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Brouet de trotteur'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Chili de crabe épicé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Cidre de pomme chaud'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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ôtelettes de lion épicé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 = 'Côtes de porc séché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 = 'Délice de déviant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Délice de gangre-queue'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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élice de sagerelle'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Hamburger dimensionnel'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Morue rochécaille'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Pain épicé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Palourdes 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 = 'Perche fumé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 = 'Queue de lézard croquante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Ragoût 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 = 'Ragoût épais de crocilisque'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Saucisse d\'araigné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 = 'Saumon solécaille poché'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak de barracuda'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak de grand ours'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak de loup'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak de loup tendre'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Surprise d\'araignée croustillante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Thé de dorépine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Viande de loup grillé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 = 'Viande de sanglier rôtie'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Aileron-de-sang grillé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Ardeur de palourde géante'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Barracuda luisant cuit'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Basilic noirci'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Beignet de crabe'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Biscuit en pain d\'épice'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Bouchées de busard'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Boulettes fumées du désert'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Brune du capitaine Rumsey'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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 de palourdes'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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âtonnets de poisson 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 = 'Calmar grillé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Chili de souffle de dragon'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Cidre chaud'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Courante-surprise'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Croque-ravageur'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Croquettes de Kibler'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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ôtelettes foudroyantes'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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ôtelettes mok\'nathal'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
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ôtes de loup épicé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 = 'Ecrevisse épicé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 = 'En-cas sporelin'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Eperlan grillé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Festin du pêcheur'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Filet de rouget'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Fricassée de truite'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Goujon 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 = 'Gâteau au chocolat délicieux'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Jaune-queue tacheté'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Kébab d\'ours grillé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lait de poule'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Lutjan à longue mâchoire'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Maquereau ombré'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Oeufs aux herbes'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Omelette au goût étrange'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Omelette monstrueuse'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Pain de saumon'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Palourdes bouillies'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Poisson-boue grillé'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Poisson-chat moustachu'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Poisson-spore noirci'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Ragoût de homard'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Ragoût de la jungle'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Ragoût épais de kodo'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Rôti de raptor'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Sabot-fourchu rôti'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Sagerelle fumé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 = 'Serpent croustillant'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Soupe de lutjan nagenuit'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Soupe de palourdes d\'Undermine'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Soupe de poisson-crâne'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steack dimensionnel'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak d\'ours juteux'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak de coyote'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak de lynx'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak de talbuk'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Steak dimensionnel'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Tassergal poché'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Thon arc-en-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 = 'Thé de chardon'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Tourte surprise'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Truite au beurre 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 = 'Truite noircie'
ORDER by m.name
SELECT m.name, r.difficulty, s.skill_level
FROM roster_members m, roster_recipes r, roster_skills s
WHERE r.member_id = m.member_id
AND r.member_id = s.member_id
AND r.skill_name = s.skill_name
AND recipe_name = 'Truite tête-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 = 'Viande d\'ours fumé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 = 'Viande de loup épicé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