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