SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Romania' AND `server` = 'Tarren Mill'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Romania' AND `server` ='Tarren Mill'
SELECT IF(`guild_title` LIKE '%alt%',1,0) AS 'isalt',
FLOOR(`level`/10) AS levelgroup,
COUNT(`level`) AS amount,
SUM(`level`) AS sum
FROM `roster_members`
GROUP BY isalt, levelgroup
ORDER BY isalt ASC, levelgroup DESC
SELECT name, level, member_id, class, clientLocale FROM `roster_players` GROUP BY name ORDER BY name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '135' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 135 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 135 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '150' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 150 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 150 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Key to the City' AND `member_id` = '150'
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '49' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 49 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 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 = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '4' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 4 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 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 = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '57' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 57 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 57 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '2' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 2 AND ( items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 2 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'The Scarlet Key' AND `member_id` = '2'
SELECT * FROM `roster_items` WHERE `item_name` = 'Mallet of Zul\'Farrak' AND `member_id` = '2'
SELECT * FROM `roster_items` WHERE `item_name` = 'Scepter of Celebras' AND `member_id` = '2'
SELECT * FROM `roster_items` WHERE `item_name` = 'Shadowforge Key' AND `member_id` = '2'
SELECT * FROM `roster_items` WHERE `item_name` = 'Crescent Key' AND `member_id` = '2'
SELECT * FROM `roster_items` WHERE `item_name` = 'Skeleton Key' AND `member_id` = '2'
SELECT * FROM `roster_items` WHERE `item_name` = 'Drakefire Amulet' AND `member_id` = '2'
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '56' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 56 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 56 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Workshop Key' AND `member_id` = '56'
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '14' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 14 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 14 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '88' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 88 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 88 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 88 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 88 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 88 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 88 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 88 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 88 and skill_name = 'Lockpicking'
SELECT members.name, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 88 AND ( items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 88 AND ( quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '88'
SELECT * FROM `roster_items` WHERE `item_name` = 'Prison Cell Key' AND `member_id` = '88'
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '88'
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '88'
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '31' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 31 AND ( items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 31 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '29' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 29 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 29 AND ( quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Key to Searing Gorge' AND `member_id` = '29'
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '93' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 93 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 93 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC 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 = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 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 = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 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 = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '193' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 193 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 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 = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '184' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 184 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 184 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '75' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 75 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 75 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '78' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 78 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 78 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '134' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 134 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 134 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '147' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 147 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 147 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '148' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 148 and skill_name = 'Lockpicking'
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 148 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '148'
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '148'
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '148'
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '148'
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '148'
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '148'
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '148'
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '85' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 85 AND ( items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 85 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '84' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 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 = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 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 = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '105' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 105 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 105 AND ( quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '73' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 73 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 73 AND ( quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '70' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 70 and skill_name = 'Lockpicking'
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 70 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 70 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Key to Searing Gorge', -1, 0)) as SG, sum(if(items.item_name = 'Workshop Key', -1, 0)) as Gnome, sum(if(items.item_name = 'The Scarlet Key', -1, 0)) as SM, sum(if(items.item_name = 'Mallet of Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Scepter of Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Prison Cell Key', -1, 0)) as BRDp, sum(if(items.item_name = 'Shadowforge Key', -1, 0)) as BRDs, sum(if(items.item_name = 'Crescent Key', -1, 0)) as DM, sum(if(items.item_name = 'Skeleton Key', -1, 0)) as Scholo, sum(if(items.item_name = 'Key to the City', -1, 0)) as Strath, sum(if(items.item_name = 'Seal of Ascension', -1, 0)) as UBRS, sum(if(items.item_name = 'Drakefire Amulet', -1, 0)) as Onyxia, sum(if(items.item_name = 'Eternal Quintessence', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '167' AND ( items.item_name = 'Key to Searing Gorge' or items.item_name = 'Workshop Key' or items.item_name = 'The Scarlet Key' or items.item_name = 'Mallet of Zul\'Farrak' or items.item_name = 'Scepter of Celebras' or items.item_name = 'Prison Cell Key' or items.item_name = 'Shadowforge Key' or items.item_name = 'Crescent Key' or items.item_name = 'Skeleton Key' or items.item_name = 'Key to the City' or items.item_name = 'Seal of Ascension' or items.item_name = 'Drakefire Amulet' or items.item_name = 'Eternal Quintessence') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Sacred Mallet', 1, 0)) AS ZF1, sum(if(items.item_name = 'Celebrian Rod', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Celebrian Diamond', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ironfel', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Unadorned Seal of Ascension', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gemstone of Spirestone', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gemstone of Smolderthorn', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gemstone of Bloodaxe', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Unforged Seal of Ascension', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Forged Seal of Ascension', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 167 AND ( items.item_name = 'Sacred Mallet' OR items.item_name = 'Celebrian Rod' OR items.item_name = 'Celebrian Diamond' OR items.item_name = 'Ironfel' OR items.item_name = 'Unadorned Seal of Ascension' OR items.item_name = 'Gemstone of Spirestone' OR items.item_name = 'Gemstone of Smolderthorn' OR items.item_name = 'Gemstone of Bloodaxe' OR items.item_name = 'Unforged Seal of Ascension' OR items.item_name = 'Forged Seal of Ascension') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Drakefire Amulet', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 167 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Drakefire Amulet') GROUP BY members.name ORDER BY members.name ASC