Les fondateurs d Azeroth @ Krasus (PvE)
Dernière mise à jour: 20/06/2007 00:39:51 (PST)
Membres: 58 (+4 Alts)
  • Average Level: 58
  • Niveau 70: 29
  • Niveau 60-69: 18
  • Niveau 50-59: 4
  • Niveau 40-49: 2
  • Niveau 30-39: 1
  • Niveau 1-29: 8
WoW Server Status


Name SG Gnome SM ZF Marau BRDp BRDs HT Scholo Strath UBRS Onyxia MC
Arancar
Druide (70)
             
Parts
1/6
   
Bractouit
Mage (70)
             
Criss
Guerrier (70)
                   
Dlb
Prêtre (66)
                     
Genova
Chasseur (70)
     
Parts
1/6
   
Gibus
Druide (70)
                 
Hybryde
Voleur (44)
                 
Hysterio
Chaman (69)
     
Parts
1/6
   
Joejoe
Paladin (67)
                   
Liliuth
Démoniste (59)
                       
Medaemon
Démoniste (70)
                     
Mmauro
Chasseur (70)
             
Parts
1/6
 
Rhôber
Chasseur (70)
       
Parts
1/6
   
Selene
Voleur (70)
   
Parts
2/6
   
Violente
Prêtre (70)
         
Parts
1/6
   
Zirox
Paladin (61)
           
Parts
1/6
   


WoWRoster v1.7.3

Props to Celandro, Paleblackness, Pytte, Rubricsinger, and Konkers for the original code used for this site.
WoWRoster home - www.wowroster.net
World of Warcraft and Blizzard Entertainment are trademarks or registered trademarks of Blizzard Entertainment, Inc. in the U.S. and/or other countries. All other trademarks are the property of their respective owners.
Additional Credits


Valid HTML 4.0 Transitional

This page was created in 0.58 seconds with 100 queries executed

SQL Queries
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Les fondateurs d Azeroth' AND `server` = 'Krasus'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Les fondateurs d Azeroth' AND `server` ='Krasus'
SELECT IF(`guild_title` LIKE '%civil%',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
SELECT name, level, member_id, class, clientLocale FROM `roster_players` GROUP BY name ORDER BY name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '25' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 25 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 25 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'La Clé écarlate' AND `member_id` = '25'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé de la prison' AND `member_id` = '25'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé de la ville' AND `member_id` = '25'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '13' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 13 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 13 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé d\'atelier' AND `member_id` = '13'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé squelette' AND `member_id` = '13'
SELECT * FROM `roster_items` WHERE `item_name` = 'Sceau d\'ascension' AND `member_id` = '13'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '36' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 36 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 36 AND ( quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé de la gorge des Vents brûlants' AND `member_id` = '36'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '30' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 30 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 30 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '57' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 57 AND ( items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 57 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Marteau de Zul\'Farrak' AND `member_id` = '57'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '35' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 35 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 35 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '18' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 18 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 18 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Sceptre de Celebras' AND `member_id` = '18'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé ombreforge' AND `member_id` = '18'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '80' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 80 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 80 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Amulette Drakefeu' AND `member_id` = '80'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '31' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 31 and skill_name = 'Crochetage'
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 31 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 31 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '31'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '31'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '31'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '31'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '41' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 41 AND ( items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 41 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '38' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 38 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 38 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '39' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 39 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 39 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '51' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 51 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 51 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé en croissant' AND `member_id` = '51'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '15' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 15 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 15 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '63' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 63 AND ( items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 63 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '4' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 4 AND ( items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 4 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '45' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 45 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 45 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 45 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 45 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 45 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 45 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 45 and skill_name = 'Crochetage'
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 45 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 45 AND ( quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '45'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '45'
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '42' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 42 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Fragments de squelette', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Moisissure rime avec...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Plume de feu forgée', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Le Scarabée d\'Araj', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'La clé de la Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 42 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Fragments de squelette' OR quests.quest_name = 'Moisissure rime avec...' OR quests.quest_name = 'Plume de feu forgée' OR quests.quest_name = 'Le Scarabée d\'Araj' OR quests.quest_name = 'La clé de la Scholomance' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé de la gorge des Vents brûlants', -1, 0)) as SG, sum(if(items.item_name = 'Clé d\'atelier', -1, 0)) as Gnome, sum(if(items.item_name = 'La Clé écarlate', -1, 0)) as SM, sum(if(items.item_name = 'Marteau de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Sceptre de Celebras', -1, 0)) as Marau, sum(if(items.item_name = 'Clé de la prison', -1, 0)) as BRDp, sum(if(items.item_name = 'Clé ombreforge', -1, 0)) as BRDs, sum(if(items.item_name = 'Clé en croissant', -1, 0)) as HT, sum(if(items.item_name = 'Clé squelette', -1, 0)) as Scholo, sum(if(items.item_name = 'Clé de la ville', -1, 0)) as Strath, sum(if(items.item_name = 'Sceau d\'ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Amulette Drakefeu', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintessence éternelle', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '43' AND ( items.item_name = 'Clé de la gorge des Vents brûlants' or items.item_name = 'Clé d\'atelier' or items.item_name = 'La Clé écarlate' or items.item_name = 'Marteau de Zul\'Farrak' or items.item_name = 'Sceptre de Celebras' or items.item_name = 'Clé de la prison' or items.item_name = 'Clé ombreforge' or items.item_name = 'Clé en croissant' or items.item_name = 'Clé squelette' or items.item_name = 'Clé de la ville' or items.item_name = 'Sceau d\'ascension' or items.item_name = 'Amulette Drakefeu' or items.item_name = 'Quintessence éternelle') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1, sum(if(items.item_name = 'Bâtonnet de Celebras', 1, 0)) AS Marau1, sum(if(items.item_name = 'Diamant de Celebras', 1, 0)) AS Marau2, sum(if(items.item_name = 'Souillefer', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sceau d\'ascension non décoré', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemme de Pierre-du-pic', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemme de Brûleronce', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemme de Hache-sanglante', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sceau d\'ascension brut ', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sceau d\'ascension forgé', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 43 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Bâtonnet de Celebras' OR items.item_name = 'Diamant de Celebras' OR items.item_name = 'Souillefer' OR items.item_name = 'Sceau d\'ascension non décoré' OR items.item_name = 'Gemme de Pierre-du-pic' OR items.item_name = 'Gemme de Brûleronce' OR items.item_name = 'Gemme de Hache-sanglante' OR items.item_name = 'Sceau d\'ascension brut ' OR items.item_name = 'Sceau d\'ascension forgé') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'La Corne de la Bête', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Titre de propriété', 1, 0)) AS SG2, sum(if(quests.quest_name = 'Enfin !', 1, 0)) AS SG3, sum(if(quests.quest_name = 'La menace dragonkin', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Les véritables maîtres', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Maréchal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Espoir abandonné', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Une Note chiffonnée', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Un espoir en lambeaux', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Evasion !', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Le rendez-vous à Stormwind', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'La grande mascarade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'Oeil de Dragon', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amulette drakefeu', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 43 AND ( quests.quest_name = 'La Corne de la Bête' OR quests.quest_name = 'Titre de propriété' OR quests.quest_name = 'Enfin !' OR quests.quest_name = 'La menace dragonkin' OR quests.quest_name = 'Les véritables maîtres' OR quests.quest_name = 'Maréchal Windsor' OR quests.quest_name = 'Espoir abandonné' OR quests.quest_name = 'Une Note chiffonnée' OR quests.quest_name = 'Un espoir en lambeaux' OR quests.quest_name = 'Evasion !' OR quests.quest_name = 'Le rendez-vous à Stormwind' OR quests.quest_name = 'La grande mascarade' OR quests.quest_name = 'L\'Oeil de Dragon' OR quests.quest_name = 'Amulette drakefeu') GROUP BY members.name ORDER BY members.name ASC