BC Keys

SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Nox Oriens' AND `server` = 'Lightninghoof'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Nox Oriens' AND `server` ='Lightninghoof'
SELECT IF(`guild_title` LIKE '%%',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 = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK 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 = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
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 = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'The Master\'s Key' AND `member_id` = '93'
SELECT * FROM `roster_items` WHERE `item_name` = 'Auchenai Key' AND `member_id` = '93'
SELECT * FROM `roster_items` WHERE `item_name` = 'Flamewrought Key' AND `member_id` = '93'
SELECT * FROM `roster_items` WHERE `item_name` = 'Reservoir Key' AND `member_id` = '93'
SELECT * FROM `roster_items` WHERE `item_name` = 'Warpforged Key' AND `member_id` = '93'
SELECT * FROM `roster_items` WHERE `item_name` = 'Key of Time' AND `member_id` = '93'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '176' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 176 AND ( reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 176 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Shattered Halls Key' AND `member_id` = '176'
SELECT * FROM `roster_items` WHERE `item_name` = 'Key to the Arcatraz' AND `member_id` = '176'
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 176
AND reputation.name='Keepers of Time'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '53' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 53 AND ( reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 53 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Shadow Labyrinth Key' AND `member_id` = '53'
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 53
AND reputation.name='Keepers of Time'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '107' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 107 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '96' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 96 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '61' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 61 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 61 and skill_name = 'Lockpicking'
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 61 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Thieves\' Tools' AND `member_id` = '61'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '32' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Lower City' THEN 'HA' WHEN 'Honor Hold' THEN 'HHC' WHEN 'Cenarion Expedition' THEN 'HCR' WHEN 'The Sha\'tar' THEN 'HTK' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 32 AND ( reputation.name = 'Lower City' OR reputation.name = 'Honor Hold' OR reputation.name = 'Cenarion Expedition' OR reputation.name = 'The Sha\'tar' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Arcane Disturbances', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'Restless Activity', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Contact from Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'Entry Into Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'The Second and Third Fragments', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'The Master\'s Touch', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Return to Khadgar', 1, 0)) AS Kara8, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 32 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Arcane Disturbances' OR quests.quest_name = 'Restless Activity' OR quests.quest_name = 'Contact from Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'Entry Into Karazhan' OR quests.quest_name = 'The Second and Third Fragments' OR quests.quest_name = 'The Master\'s Touch' OR quests.quest_name = 'Return to Khadgar' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '68' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Lower City' THEN 'HA' WHEN 'Honor Hold' THEN 'HHC' WHEN 'Cenarion Expedition' THEN 'HCR' WHEN 'The Sha\'tar' THEN 'HTK' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 68 AND ( reputation.name = 'Lower City' OR reputation.name = 'Honor Hold' OR reputation.name = 'Cenarion Expedition' OR reputation.name = 'The Sha\'tar' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Arcane Disturbances', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'Restless Activity', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Contact from Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'Entry Into Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'The Second and Third Fragments', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'The Master\'s Touch', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Return to Khadgar', 1, 0)) AS Kara8, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 68 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Arcane Disturbances' OR quests.quest_name = 'Restless Activity' OR quests.quest_name = 'Contact from Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'Entry Into Karazhan' OR quests.quest_name = 'The Second and Third Fragments' OR quests.quest_name = 'The Master\'s Touch' OR quests.quest_name = 'Return to Khadgar' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '30' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 30 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '127' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Lower City' THEN 'HA' WHEN 'Honor Hold' THEN 'HHC' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 127 AND ( reputation.name = 'Lower City' OR reputation.name = 'Honor Hold' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Arcane Disturbances', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'Restless Activity', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Contact from Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'Entry Into Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'The Second and Third Fragments', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'The Master\'s Touch', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Return to Khadgar', 1, 0)) AS Kara8, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 127 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Arcane Disturbances' OR quests.quest_name = 'Restless Activity' OR quests.quest_name = 'Contact from Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'Entry Into Karazhan' OR quests.quest_name = 'The Second and Third Fragments' OR quests.quest_name = 'The Master\'s Touch' OR quests.quest_name = 'Return to Khadgar' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 127
AND reputation.name='Lower City'
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 127
AND reputation.name='Honor Hold'
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 127
AND reputation.name='Keepers of Time'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '164' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 164 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK 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 = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
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 = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '13' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 13 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK 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 = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 57 and skill_name = 'Lockpicking'
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Lower City' THEN 'HA' WHEN 'Cenarion Expedition' THEN 'HCR' WHEN 'The Sha\'tar' THEN 'HTK' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 57 AND ( reputation.name = 'Lower City' OR reputation.name = 'Cenarion Expedition' OR reputation.name = 'The Sha\'tar' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Arcane Disturbances', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'Restless Activity', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Contact from Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'Entry Into Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'The Second and Third Fragments', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'The Master\'s Touch', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Return to Khadgar', 1, 0)) AS Kara8, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
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 = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Arcane Disturbances' OR quests.quest_name = 'Restless Activity' OR quests.quest_name = 'Contact from Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'Entry Into Karazhan' OR quests.quest_name = 'The Second and Third Fragments' OR quests.quest_name = 'The Master\'s Touch' OR quests.quest_name = 'Return to Khadgar' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 57
AND reputation.name='Lower City'
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 57
AND reputation.name='Cenarion Expedition'
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 57
AND reputation.name='The Sha\'tar'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK 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 = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Lower City' THEN 'HA' WHEN 'Honor Hold' THEN 'HHC' WHEN 'Cenarion Expedition' THEN 'HCR' WHEN 'The Sha\'tar' THEN 'HTK' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 148 AND ( reputation.name = 'Lower City' OR reputation.name = 'Honor Hold' OR reputation.name = 'Cenarion Expedition' OR reputation.name = 'The Sha\'tar' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Arcane Disturbances', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'Restless Activity', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Contact from Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'Entry Into Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'The Second and Third Fragments', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'The Master\'s Touch', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Return to Khadgar', 1, 0)) AS Kara8, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 148 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Arcane Disturbances' OR quests.quest_name = 'Restless Activity' OR quests.quest_name = 'Contact from Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'Entry Into Karazhan' OR quests.quest_name = 'The Second and Third Fragments' OR quests.quest_name = 'The Master\'s Touch' OR quests.quest_name = 'Return to Khadgar' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '169' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Lower City' THEN 'HA' WHEN 'Honor Hold' THEN 'HHC' WHEN 'Cenarion Expedition' THEN 'HCR' WHEN 'The Sha\'tar' THEN 'HTK' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 169 AND ( reputation.name = 'Lower City' OR reputation.name = 'Honor Hold' OR reputation.name = 'Cenarion Expedition' OR reputation.name = 'The Sha\'tar' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Arcane Disturbances', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'Restless Activity', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Contact from Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'Entry Into Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'The Second and Third Fragments', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'The Master\'s Touch', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Return to Khadgar', 1, 0)) AS Kara8, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 169 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Arcane Disturbances' OR quests.quest_name = 'Restless Activity' OR quests.quest_name = 'Contact from Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'Entry Into Karazhan' OR quests.quest_name = 'The Second and Third Fragments' OR quests.quest_name = 'The Master\'s Touch' OR quests.quest_name = 'Return to Khadgar' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK 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 = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
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 = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '174' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 174 AND ( quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '72' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Lower City' THEN 'HA' WHEN 'Honor Hold' THEN 'HHC' WHEN 'Cenarion Expedition' THEN 'HCR' WHEN 'The Sha\'tar' THEN 'HTK' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 72 AND ( reputation.name = 'Lower City' OR reputation.name = 'Honor Hold' OR reputation.name = 'Cenarion Expedition' OR reputation.name = 'The Sha\'tar' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Arcane Disturbances', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'Restless Activity', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Contact from Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'Entry Into Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'The Second and Third Fragments', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'The Master\'s Touch', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Return to Khadgar', 1, 0)) AS Kara8, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 72 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Arcane Disturbances' OR quests.quest_name = 'Restless Activity' OR quests.quest_name = 'Contact from Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'Entry Into Karazhan' OR quests.quest_name = 'The Second and Third Fragments' OR quests.quest_name = 'The Master\'s Touch' OR quests.quest_name = 'Return to Khadgar' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '87' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 87 AND ( reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 87 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 87
AND reputation.name='Keepers of Time'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '50' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 50 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '34' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Honor Hold' THEN 'HHC' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 34 AND ( reputation.name = 'Honor Hold') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 34 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 34
AND reputation.name='Honor Hold'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '9' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Honor Hold' THEN 'HHC' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 9 AND ( reputation.name = 'Honor Hold' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 9 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 9
AND reputation.name='Honor Hold'
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 9
AND reputation.name='Keepers of Time'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '114' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT reputation.name, reputation.standing, (CASE reputation.name WHEN 'Lower City' THEN 'HA' WHEN 'The Sha\'tar' THEN 'HTK' WHEN 'Keepers of Time' THEN 'HCoT' END) AS rkey
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 114 AND ( reputation.name = 'Lower City' OR reputation.name = 'The Sha\'tar' OR reputation.name = 'Keepers of Time') ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Entry into the Citadel', 1, 0)) AS SH1, sum(if(quests.quest_name = 'Grand Master Dumphry', 1, 0)) AS SH2, sum(if(quests.quest_name = 'Dumphry\'s Request', 1, 0)) AS SH3, sum(if(quests.quest_name = 'Hotter then Hell', 1, 0)) AS SH4, sum(if(quests.quest_name = 'Warp-Raider Nesaad', 1, 0)) AS Arcatraz1, sum(if(quests.quest_name = 'Request for Assistance', 1, 0)) AS Arcatraz2, sum(if(quests.quest_name = 'Rightful Repossession', 1, 0)) AS Arcatraz3, sum(if(quests.quest_name = 'An Audience with the Prince', 1, 0)) AS Arcatraz4, sum(if(quests.quest_name = 'Triangulation Point One', 1, 0)) AS Arcatraz5, sum(if(quests.quest_name = 'Triangulation Point Two', 1, 0)) AS Arcatraz6, sum(if(quests.quest_name = 'Full Triangle', 1, 0)) AS Arcatraz7, sum(if(quests.quest_name = 'Special Delivery to Shattrath City', 1, 0)) AS Arcatraz8, sum(if(quests.quest_name = 'How to Break Into the Arcatraz', 1, 0)) AS Arcatraz9, sum(if(quests.quest_name = 'Arcane Disturbances', 1, 0)) AS Kara1, sum(if(quests.quest_name = 'Restless Activity', 1, 0)) AS Kara2, sum(if(quests.quest_name = 'Contact from Dalaran', 1, 0)) AS Kara3, sum(if(quests.quest_name = 'Khadgar', 1, 0)) AS Kara4, sum(if(quests.quest_name = 'Entry Into Karazhan', 1, 0)) AS Kara5, sum(if(quests.quest_name = 'The Second and Third Fragments', 1, 0)) AS Kara6, sum(if(quests.quest_name = 'The Master\'s Touch', 1, 0)) AS Kara7, sum(if(quests.quest_name = 'Return to Khadgar', 1, 0)) AS Kara8, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 114 AND ( quests.quest_name = 'Entry into the Citadel' OR quests.quest_name = 'Grand Master Dumphry' OR quests.quest_name = 'Dumphry\'s Request' OR quests.quest_name = 'Hotter then Hell' OR quests.quest_name = 'Warp-Raider Nesaad' OR quests.quest_name = 'Request for Assistance' OR quests.quest_name = 'Rightful Repossession' OR quests.quest_name = 'An Audience with the Prince' OR quests.quest_name = 'Triangulation Point One' OR quests.quest_name = 'Triangulation Point Two' OR quests.quest_name = 'Full Triangle' OR quests.quest_name = 'Special Delivery to Shattrath City' OR quests.quest_name = 'How to Break Into the Arcatraz' OR quests.quest_name = 'Arcane Disturbances' OR quests.quest_name = 'Restless Activity' OR quests.quest_name = 'Contact from Dalaran' OR quests.quest_name = 'Khadgar' OR quests.quest_name = 'Entry Into Karazhan' OR quests.quest_name = 'The Second and Third Fragments' OR quests.quest_name = 'The Master\'s Touch' OR quests.quest_name = 'Return to Khadgar' OR quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 114
AND reputation.name='Lower City'
SELECT reputation.name, reputation.standing, reputation.curr_rep, reputation.max_rep
FROM `roster_reputation` reputation
LEFT JOIN `roster_members` members ON members.member_id = reputation.member_id
WHERE reputation.member_id = 114
AND reputation.name='The Sha\'tar'
SELECT members.name, sum(if(items.item_name = 'Shattered Halls Key', -1, 0)) as SH, sum(if(items.item_name = 'Shadow Labyrinth Key', -1, 0)) as SL, sum(if(items.item_name = 'Key to the Arcatraz', -1, 0)) as Arcatraz, sum(if(items.item_name = 'The Master\'s Key', -1, 0)) as Kara, sum(if(items.item_name = 'Auchenai Key', -1, 0)) as HA, sum(if(items.item_name = 'Flamewrought Key', -1, 0)) as HHC, sum(if(items.item_name = 'Reservoir Key', -1, 0)) as HCR, sum(if(items.item_name = 'Warpforged Key', -1, 0)) as HTK, sum(if(items.item_name = 'Key of Time', -1, 0)) as HCoT, sum(if(items.item_name = 'The Tempest Key', -1, 0)) as TK FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '109' AND ( items.item_name = 'Shattered Halls Key' or items.item_name = 'Shadow Labyrinth Key' or items.item_name = 'Key to the Arcatraz' or items.item_name = 'The Master\'s Key' or items.item_name = 'Auchenai Key' or items.item_name = 'Flamewrought Key' or items.item_name = 'Reservoir Key' or items.item_name = 'Warpforged Key' or items.item_name = 'Key of Time' or items.item_name = 'The Tempest Key') GROUP BY members.name
SELECT members.name, sum(if(quests.quest_name = 'Oronok Torn-heart', 1, 0)) AS TK1, sum(if(quests.quest_name = 'I Was A Lot Of Things...', 1, 0)) AS TK2, sum(if(quests.quest_name = 'A Lesson Learned', 1, 0)) AS TK3, sum(if(quests.quest_name = 'The Cipher of Damnation - Thruth and History', 1, 0)) AS TK4, sum(if(quests.quest_name = 'Grom\'tor, Son of Oronok', 1, 0)) AS TK5, sum(if(quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge', 1, 0)) AS TK6, sum(if(quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered', 1, 0)) AS TK7, sum(if(quests.quest_name = 'Ar\'tor, Son of Oronok', 1, 0)) AS TK8, sum(if(quests.quest_name = 'Demonic Crystal Prisons', 1, 0)) AS TK9, sum(if(quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart', 1, 0)) AS TK10, sum(if(quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge', 1, 0)) AS TK11, sum(if(quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered', 1, 0)) AS TK12, sum(if(quests.quest_name = 'Borak, Son of Oronok', 1, 0)) AS TK13, sum(if(quests.quest_name = 'Of Thistleheads and Eggs...', 1, 0)) AS TK14, sum(if(quests.quest_name = 'The Bundle of Bloodthistle', 1, 0)) AS TK15, sum(if(quests.quest_name = 'To Catch A Thistlehead', 1, 0)) AS TK16, sum(if(quests.quest_name = 'The Shadowmoon Shuffle', 1, 0)) AS TK17, sum(if(quests.quest_name = 'What Illidan Wants, Illidan Gets...', 1, 0)) AS TK18, sum(if(quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge', 1, 0)) AS TK19, sum(if(quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered', 1, 0)) AS TK20, sum(if(quests.quest_name = 'The Cipher of Damnation', 1, 0)) AS TK21, sum(if(quests.quest_name = 'Trial of the Naaru: Mercy', 1, 0)) AS TK22, sum(if(quests.quest_name = 'Trial of the Naaru: Strength', 1, 0)) AS TK23, sum(if(quests.quest_name = 'Trial of the Naaru: Tenacity', 1, 0)) AS TK24, sum(if(quests.quest_name = 'Trial of the Naaru: Magtheridon', 1, 0)) AS TK25
FROM `roster_quests` quests
LEFT JOIN `roster_members` members ON members.member_id = quests.member_id
WHERE quests.member_id = 109 AND ( quests.quest_name = 'Oronok Torn-heart' OR quests.quest_name = 'I Was A Lot Of Things...' OR quests.quest_name = 'A Lesson Learned' OR quests.quest_name = 'The Cipher of Damnation - Thruth and History' OR quests.quest_name = 'Grom\'tor, Son of Oronok' OR quests.quest_name = 'The Cipher of Damnation - Grom\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The First Fragment Recovered' OR quests.quest_name = 'Ar\'tor, Son of Oronok' OR quests.quest_name = 'Demonic Crystal Prisons' OR quests.quest_name = 'Lohn\'goron, Bow of the Torn-heart' OR quests.quest_name = 'The Cipher of Damnation - Ar\'tor\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Second Fragment Recovered' OR quests.quest_name = 'Borak, Son of Oronok' OR quests.quest_name = 'Of Thistleheads and Eggs...' OR quests.quest_name = 'The Bundle of Bloodthistle' OR quests.quest_name = 'To Catch A Thistlehead' OR quests.quest_name = 'The Shadowmoon Shuffle' OR quests.quest_name = 'What Illidan Wants, Illidan Gets...' OR quests.quest_name = 'The Cipher of Damnation - Borak\'s Charge' OR quests.quest_name = 'The Cipher of Damnation - The Third Fragment Recovered' OR quests.quest_name = 'The Cipher of Damnation' OR quests.quest_name = 'Trial of the Naaru: Mercy' OR quests.quest_name = 'Trial of the Naaru: Strength' OR quests.quest_name = 'Trial of the Naaru: Tenacity' OR quests.quest_name = 'Trial of the Naaru: Magtheridon')
GROUP BY members.name ORDER BY members.name ASC