|
||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
||