Clefs BC

SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` = 'Dalaran'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Dark side of the Horde' AND `server` ='Dalaran'
SELECT IF(`note` LIKE '%reroll%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC
SELECT name, level, member_id, class, clientLocale FROM `roster_players` GROUP BY name ORDER BY name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '266' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 266 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '119' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 119 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé du labyrinthe des ombres' AND `member_id` = '119'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé de l\'Arcatraz' AND `member_id` = '119'
SELECT * FROM `roster_items` WHERE `item_name` = 'La clé du maître' AND `member_id` = '119'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé Auchenaï' AND `member_id` = '119'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé en flammes forgées' AND `member_id` = '119'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé du réservoir' AND `member_id` = '119'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé dimensionnelle' AND `member_id` = '119'
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '13' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 13 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '138' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 138 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '67' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 67 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '29' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 29 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '95' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 95 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '79' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 79 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '234' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 234 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '261' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 261 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '263' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 263 and skill_name = 'Crochetage'
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 263 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '279' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 279 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '367' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 367 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '16' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 16 AND ( quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé des Salles Brisées' AND `member_id` = '16'
SELECT * FROM `roster_items` WHERE `item_name` = 'Clé du Temps' AND `member_id` = '16'
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '271' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 271 and skill_name = 'Crochetage'
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 271 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '296' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 296 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '280' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 280 and skill_name = 'Crochetage'
SELECT members.name, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 280 AND ( quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '280'
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '282' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 282 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '26' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 26 AND ( quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '5' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 5 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '46' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 46 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '126' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 126 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT 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é du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 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 = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '368' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 368 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '254' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 254 AND ( quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '370' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 370 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '257' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 257 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '260' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 260 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '317' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 317 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '4' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 4 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '84' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 84 and skill_name = 'Crochetage'
SELECT members.name, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 84 AND ( quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Outils de Voleur' AND `member_id` = '84'
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '30' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 30 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '274' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 274 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '269' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 269 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '91' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 91 AND ( quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '193' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 193 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '86' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 86 and skill_name = 'Crochetage'
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 86 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '24' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 24 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '49' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT skill_level FROM `roster_skills` WHERE member_id = 49 and skill_name = 'Crochetage'
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 49 AND ( quests.quest_name = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '281' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 281 AND ( quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT 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é du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'entrée dans la citadelle', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Le grand maître Rohok', 1, 0)) AS SH2, sum(if(quests.quest_name = 'La demande de Rohok', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Plus chaud que l\'enfer', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Point de triangulation numéro un', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Point de triangulation numéro deux', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Le triangle est triangulé', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Comment pénétrer dans l\'Arcatraz', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5, sum(if(quests.quest_name = 'Troubles arcaniques', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'L\'agitation des sans-repos', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Un envoyé de Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'L\'entrée de Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'Le deuxième et le troisième fragment', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'Le toucher du maître', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Retour vers Khadgar', 1, 0)) AS Kara8 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 = 'L\'entrée dans la citadelle' OR quests.quest_name = 'Le grand maître Rohok' OR quests.quest_name = 'La demande de Rohok' OR quests.quest_name = 'Plus chaud que l\'enfer' OR quests.quest_name = 'Point de triangulation numéro un' OR quests.quest_name = 'Point de triangulation numéro deux' OR quests.quest_name = 'Le triangle est triangulé' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'Comment pénétrer dans l\'Arcatraz' OR quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête' OR quests.quest_name = 'Troubles arcaniques' OR quests.quest_name = 'L\'agitation des sans-repos' OR quests.quest_name = 'Un envoyé de Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'L\'entrée de Karazhan' OR quests.quest_name = 'Le deuxième et le troisième fragment' OR quests.quest_name = 'Le toucher du maître' OR quests.quest_name = 'Retour vers Khadgar') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Clé du labyrinthe des ombres', -1, 0)) as SL, sum(if(items.item_name = 'Clé des Salles Brisées', -1, 0)) as SH, sum(if(items.item_name = 'Clé de l\'Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'La clé de la Tempête', -1, 0)) as TK, sum(if(items.item_name = 'La clé du maître', -1, 0)) as Kara, sum(if(items.item_name = 'Clé Auchenaï', -1, 0)) as HA, sum(if(items.item_name = 'Clé en flammes forgées', -1, 0)) as HHC, sum(if(items.item_name = 'Clé du réservoir', -1, 0)) as HCR, sum(if(items.item_name = 'Clé dimensionnelle', -1, 0)) as HTK, sum(if(items.item_name = 'Clé du Temps', -1, 0)) as HCoT FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '118' AND ( items.item_name = 'Clé du labyrinthe des ombres' or items.item_name = 'Clé des Salles Brisées' or items.item_name = 'Clé de l\'Arcatraz' or items.item_name = 'La clé de la Tempête' or items.item_name = 'La clé du maître' or items.item_name = 'Clé Auchenaï' or items.item_name = 'Clé en flammes forgées' or items.item_name = 'Clé du réservoir' or items.item_name = 'Clé dimensionnelle' or items.item_name = 'Clé du Temps') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'L\'épreuve des naaru : Miséricorde', 1, 0)) AS TK1, sum(if(quests.quest_name = 'L\'épreuve des naaru : Force', 1, 0)) AS TK2, sum(if(quests.quest_name = 'L\'épreuve des naaru : Ténacité', 1, 0)) AS TK3, sum(if(quests.quest_name = 'Livraison spéciale à Shattrath', 1, 0)) AS TK4, sum(if(quests.quest_name = 'La clé de la Tempête', 1, 0)) AS TK5 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 118 AND ( quests.quest_name = 'L\'épreuve des naaru : Miséricorde' OR quests.quest_name = 'L\'épreuve des naaru : Force' OR quests.quest_name = 'L\'épreuve des naaru : Ténacité' OR quests.quest_name = 'Livraison spéciale à Shattrath' OR quests.quest_name = 'La clé de la Tempête') GROUP BY members.name ORDER BY members.name ASC