Clefs BC

SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Armageddon' AND `server` = 'Varimathras'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Armageddon' AND `server` ='Varimathras'
SELECT IF(`note` LIKE '%alt%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC
SELECT name, level, member_id, class, clientLocale FROM `roster_players` GROUP BY name ORDER BY name ASC
SELECT members.name, sum(if(items.item_name = 'Clé 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 = '76' 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 = 76 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