SELECT `config_name`, `config_value` FROM `roster_config` ORDER BY `id` ASC;
SELECT * FROM `roster_guild` WHERE `guild_name` = 'Orden del Manto Oscuro' AND `server` = 'Tyrande'
SELECT `guild_id`, `guild_dateupdatedutc` FROM `roster_guild` WHERE `guild_name` = 'Orden del Manto Oscuro' AND `server` ='Tyrande'
SELECT IF(`guild_title` LIKE '%alters%',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 = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '1' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 1 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 1 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '35' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 35 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 35 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Llave de taller' AND `member_id` = '35'
SELECT * FROM `roster_items` WHERE `item_name` = 'La llave Escarlata' AND `member_id` = '35'
SELECT * FROM `roster_items` WHERE `item_name` = 'Llave de celda de prisión' AND `member_id` = '35'
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '27' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 27 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 27 AND ( quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Llave de la Garganta de Fuego' AND `member_id` = '27'
SELECT * FROM `roster_items` WHERE `item_name` = 'Llave esqueleto' AND `member_id` = '27'
SELECT * FROM `roster_items` WHERE `item_name` = 'Llave de la ciudad' AND `member_id` = '27'
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '305' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 305 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 305 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '237' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 237 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 237 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '131' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 131 AND ( items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 131 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Marra de Zul\'Farrak' AND `member_id` = '131'
SELECT * FROM `roster_items` WHERE `item_name` = 'Cetro de Celebras' AND `member_id` = '131'
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '414' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT skill_level FROM `roster_skills` WHERE member_id = 414 and skill_name = 'Lockpicking'
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 414 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 414 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '433' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 433 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 433 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '63' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 63 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 63 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT * FROM `roster_items` WHERE `item_name` = 'Llave creciente' AND `member_id` = '63'
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '157' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 157 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 157 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC 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 = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 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 = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 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 = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '26' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 26 AND ( items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 26 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '375' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 375 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 375 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '90' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Vara de Celebras', 1, 0)) AS Mauro1, sum(if(items.item_name = 'Diamante de Celebras', 1, 0)) AS Mauro2, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 90 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Vara de Celebras' OR items.item_name = 'Diamante de Celebras' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Scholomance', 1, 0)) AS Scholo1, sum(if(quests.quest_name = 'Skeletal Fragments', 1, 0)) AS Scholo2, sum(if(quests.quest_name = 'Mold Rhymes With...', 1, 0)) AS Scholo3, sum(if(quests.quest_name = 'Fire Plume Forged', 1, 0)) AS Scholo4, sum(if(quests.quest_name = 'Araj\'s Scarab', 1, 0)) AS Scholo5, sum(if(quests.quest_name = 'The Key to Scholomance', 1, 0)) AS Scholo6, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 90 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Scholomance' OR quests.quest_name = 'Skeletal Fragments' OR quests.quest_name = 'Mold Rhymes With...' OR quests.quest_name = 'Fire Plume Forged' OR quests.quest_name = 'Araj\'s Scarab' OR quests.quest_name = 'The Key to Scholomance' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '2' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or items.item_name = 'Cetro de Celebras' or items.item_name = 'Llave de celda de prisión' or items.item_name = 'Llave Sombratiniebla' or items.item_name = 'Llave creciente' or items.item_name = 'Llave esqueleto' or items.item_name = 'Llave de la ciudad' or items.item_name = 'Lacre de ascensión' or items.item_name = 'Amuleto de Pirodraco' or items.item_name = 'Quintaesencia eterna') GROUP BY members.name
SELECT members.name, sum(if(items.item_name = 'Marra sacra', 1, 0)) AS ZF1, sum(if(items.item_name = 'Ferrovil', 1, 0)) AS BRDs1, sum(if(items.item_name = 'Sello de ascensión sin adornar', 1, 0)) AS UBRS1, sum(if(items.item_name = 'Gema de Cumbrerroca', 1, 0)) AS UBRS2, sum(if(items.item_name = 'Gema de Espina Ahumada', 1, 0)) AS UBRS3, sum(if(items.item_name = 'Gema de Hacha de Sangre', 1, 0)) AS UBRS4, sum(if(items.item_name = 'Sello de Ascensión sin forjar', 1, 0)) AS UBRS5, sum(if(items.item_name = 'Sello de Ascensión forjado', 1, 0)) AS UBRS6 FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = 2 AND ( items.item_name = 'Marra sacra' OR items.item_name = 'Ferrovil' OR items.item_name = 'Sello de ascensión sin adornar' OR items.item_name = 'Gema de Cumbrerroca' OR items.item_name = 'Gema de Espina Ahumada' OR items.item_name = 'Gema de Hacha de Sangre' OR items.item_name = 'Sello de Ascensión sin forjar' OR items.item_name = 'Sello de Ascensión forjado') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(quests.quest_name = 'The Horn of the Beast', 1, 0)) AS SG1, sum(if(quests.quest_name = 'Proof of Deed', 1, 0)) AS SG2, sum(if(quests.quest_name = 'At Last!', 1, 0)) AS SG3, sum(if(quests.quest_name = 'Dragonkin Menace', 1, 0)) AS Onyxia1, sum(if(quests.quest_name = 'The True Masters', 1, 0)) AS Onyxia2, sum(if(quests.quest_name = 'Marshal Windsor', 1, 0)) AS Onyxia3, sum(if(quests.quest_name = 'Abandoned Hope', 1, 0)) AS Onyxia4, sum(if(quests.quest_name = 'A Crumpled Up Note', 1, 0)) AS Onyxia5, sum(if(quests.quest_name = 'A Shred of Hope', 1, 0)) AS Onyxia6, sum(if(quests.quest_name = 'Jail Break!', 1, 0)) AS Onyxia7, sum(if(quests.quest_name = 'Stormwind Rendezvous', 1, 0)) AS Onyxia8, sum(if(quests.quest_name = 'The Great Masquerade', 1, 0)) AS Onyxia9, sum(if(quests.quest_name = 'The Dragon\'s Eye', 1, 0)) AS Onyxia10, sum(if(quests.quest_name = 'Amuleto de Pirodraco', 1, 0)) AS Onyxia11 FROM `roster_quests` quests LEFT JOIN `roster_members` members ON members.member_id = quests.member_id WHERE quests.member_id = 2 AND ( quests.quest_name = 'The Horn of the Beast' OR quests.quest_name = 'Proof of Deed' OR quests.quest_name = 'At Last!' OR quests.quest_name = 'Dragonkin Menace' OR quests.quest_name = 'The True Masters' OR quests.quest_name = 'Marshal Windsor' OR quests.quest_name = 'Abandoned Hope' OR quests.quest_name = 'A Crumpled Up Note' OR quests.quest_name = 'A Shred of Hope' OR quests.quest_name = 'Jail Break!' OR quests.quest_name = 'Stormwind Rendezvous' OR quests.quest_name = 'The Great Masquerade' OR quests.quest_name = 'The Dragon\'s Eye' OR quests.quest_name = 'Amuleto de Pirodraco') GROUP BY members.name ORDER BY members.name ASC
SELECT members.name, sum(if(items.item_name = 'Llave de la Garganta de Fuego', -1, 0)) as SG, sum(if(items.item_name = 'Llave de taller', -1, 0)) as Gnome, sum(if(items.item_name = 'La llave Escarlata', -1, 0)) as SM, sum(if(items.item_name = 'Marra de Zul\'Farrak', -1, 0)) as ZF, sum(if(items.item_name = 'Cetro de Celebras', -1, 0)) as Mauro, sum(if(items.item_name = 'Llave de celda de prisión', -1, 0)) as BRDp, sum(if(items.item_name = 'Llave Sombratiniebla', -1, 0)) as BRDs, sum(if(items.item_name = 'Llave creciente', -1, 0)) as DM, sum(if(items.item_name = 'Llave esqueleto', -1, 0)) as Scholo, sum(if(items.item_name = 'Llave de la ciudad', -1, 0)) as Strath, sum(if(items.item_name = 'Lacre de ascensión', -1, 0)) as UBRS, sum(if(items.item_name = 'Amuleto de Pirodraco', -1, 0)) as Onyxia, sum(if(items.item_name = 'Quintaesencia eterna', -1, 0)) as MC FROM `roster_items` items LEFT JOIN `roster_members` members ON members.member_id = items.member_id WHERE items.member_id = '201' AND ( items.item_name = 'Llave de la Garganta de Fuego' or items.item_name = 'Llave de taller' or items.item_name = 'La llave Escarlata' or items.item_name = 'Marra de Zul\'Farrak' or i