Dark side of the Horde @ Dalaran (PvE)
Dernière mise à jour: 25/07/2008 01:00:15 (PST)
Membres: 63 (+33 Alts)
  • Average Level: 50
  • Niveau 70: 38
  • Niveau 60-69: 10
  • Niveau 50-59: 1
  • Niveau 40-49: 15
  • Niveau 30-39: 13
  • Niveau 1-29: 19
WoW Server Status
Addons:


Name SG Gnome SM ZF Marau BRDp BRDs HT Scholo Strath UBRS Onyxia MC
Annacondo
Guerrier (39)
                       
Baffe
Druide (70)
               
Parts
2/6
 
Belgarius
Mage (68)
                       
Cénovis
Prêtre (70)
               
Parts
1/6
   
Chayenne
Chasseur (53)
                       
Chincatchouk
Chasseur (45)
                       
Duncanor
Guerrier (61)
           
Parts
1/6
   
Furtit
Voleur (62)
       
Hazgul
Prêtre (70)
               
Hellkirua
Voleur (28)
                     
Jaref
Paladin (64)
                       
Kadmilos
Voleur (70)
         
Kertro
Guerrier (70)
             
Parts
2/6
Quests
12/14
 
Laurhena
Mage (70)
           
Malykia
Démoniste (34)
                       
Mattik
Mage (70)
                 
Néna
Druide (61)
         
Parts
1/6
 
Oomorgridoo
Chamane (70)
                       
Ooraistlinoo
Démoniste (70)
 
Parts
5/6
 
Panopamelist
Prêtre (70)
         
Parts
3/6
   
Pyrocas
Mage (37)
                     
Raah
Guerrier (70)
                   
Razer
Voleur (70)
 
Rénovix
Prêtre (70)
             
Sifillisse
Mage (70)
         
Sobere
Démoniste (70)
                 
Synopsis
Voleur (37)
                   
Talmuk
Guerrier (61)
                     
Tax
Voleur (37)
                     
Tekra
Démoniste (70)
             
Quests
13/14
 
Valrok
Chasseur (70)
                 


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 2.48 seconds with 231 queries executed

SQL Queries
SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` = 'Dalaran'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` ='Dalaran'
SELECT IF(`note` LIKE '%reroll%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC
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 = '266' 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 = 266 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 266 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'La Clé écarlate' AND `member_id` = '266'
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 = '119' 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 = 119 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 = '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 = 119 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') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Marteau de Zul\'Farrak' AND `member_id` = '119'
SELECT * FROM `roster_items` WHERE `item_name` = 'Amulette Drakefeu' AND `member_id` = '119'
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, 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 = 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' 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 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 = '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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé de la ville' 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 = '138' 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 = 138 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 138 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '67' 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 = 67 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 67 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '29' 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 = 29 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 29 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '95' 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 = 95 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 95 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '79' 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 = 79 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 79 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '234' 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 = '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 = 234 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 = '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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 234 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Sceptre de Celebras' AND `member_id` = '234'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé en croissant' AND `member_id` = '234'
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 = '261' 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 = 261 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 261 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '263' 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 = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT members.name, 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 = 263 AND ( 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 263 AND ( quests.quest_name = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '263'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '263'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '263'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '263'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '263'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '263'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '263'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '263'
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 = '279' 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 = 279 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 279 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '367' 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 = 367 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 367 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '16' 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 = 16 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 * FROM `roster_items` WHERE `item_name` = 'Clé squelette' AND `member_id` = '16'
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 = '271' 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 = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 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 = 271 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 = '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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 271 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '271'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '271'
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 = '296' 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 = 296 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 = '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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 296 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '280' 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 = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 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 = 280 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 280 AND ( quests.quest_name = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé d\'atelier' AND `member_id` = '280'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
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 = '282' 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 = 282 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 282 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '26' 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 = 26 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 26 AND ( quests.quest_name = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '5' 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 = 5 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(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 = '46' 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 = 46 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 46 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '126' 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 = 126 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 126 AND ( quests.quest_name = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '23' 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 = 23 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(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 = '368' 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 = 368 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 368 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '254' 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 = 254 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 * FROM `roster_items` WHERE `item_name` = 'Clé de la prison' AND `member_id` = '254'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé ombreforge' AND `member_id` = '254'
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 = '370' 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 = 370 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 370 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '257' 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 = 257 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 257 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '260' 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 = 260 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 = '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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 260 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '317' 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 = 317 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 317 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '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 = 4 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 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 = '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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '84' 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 = 84 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT members.name, sum(if(items.item_name = 'Maillet sacré', 1, 0)) AS ZF1 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 84 AND ( items.item_name = 'Maillet sacré') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '84'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '84'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '84'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '84'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '84'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '84'
SELECT * FROM `roster_items` WHERE `item_name` = 'Sceau d\'ascension' AND `member_id` = '84'
SELECT * FROM `roster_items` WHERE `item_name` = 'Quintessence éternelle' AND `member_id` = '84'
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 = '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 = 30 AND ( items.item_name = 'Maillet sacré' OR items.item_name = 'Souillefer') 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 = '274' 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 = 274 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 274 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '269' 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 = 269 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 269 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '91' 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 = 91 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(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 = '193' 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 = 193 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(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 = '86' 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 = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 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 = 86 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 = '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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 86 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '86'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '86'
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 = '24' 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 = '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 = 24 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 = '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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 24 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '49' 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 = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 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 = 49 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 = '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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 49 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '49'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '49'
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 = '281' 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 = 281 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 281 AND ( quests.quest_name = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '99' 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 = 99 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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 99 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') 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 = '118' 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 = 118 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 = '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 = 'Ordres du seigneur de guerre Goretooth', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'Ordre du chef de guerre', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Pour la Horde !', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Ce que le vent apporte', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'Le Champion de la Horde', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'Le testament de Rexxar', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Illusions d\'Occulus', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Querelleur ardent', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'L\'épreuve des crânes, Cristallomancier', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'L\'épreuve des crânes, Somnus', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'L\'épreuve des crânes, Chronalis', 1, 0)) AS Onyxia11, sum(if(quests.quest_name = 'L\'épreuve des crânes, Axtroz', 1, 0)) AS Onyxia12, sum(if(quests.quest_name = 'Ascension...', 1, 0)) AS Onyxia13, sum(if(quests.quest_name = 'Sang du Champion des Dragons noirs', 1, 0)) AS Onyxia14 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 118 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 = 'Ordres du seigneur de guerre Goretooth' OR quests.quest_name = 'Ordre du chef de guerre' OR quests.quest_name = 'Pour la Horde !' OR quests.quest_name = 'Ce que le vent apporte' OR quests.quest_name = 'Le Champion de la Horde' OR quests.quest_name = 'Le testament de Rexxar' OR quests.quest_name = 'Illusions d\'Occulus' OR quests.quest_name = 'Querelleur ardent' OR quests.quest_name = 'L\'épreuve des crânes, Cristallomancier' OR quests.quest_name = 'L\'épreuve des crânes, Somnus' OR quests.quest_name = 'L\'épreuve des crânes, Chronalis' OR quests.quest_name = 'L\'épreuve des crânes, Axtroz' OR quests.quest_name = 'Ascension...' OR quests.quest_name = 'Sang du Champion des Dragons noirs') GROUP BY members.name ORDER BY members.name ASC