First Anniversary Contest

1

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select displayname, sum(points) as tickets 
  FROM ( SELECT owneruserid as userid, 2 as points 
           FROM posts 
          WHERE (posts.id in (SELECT posttags.postid
                               FROM tags JOIN posttags ON (tags.id = posttags.tagid)
                              WHERE tagname in ( '13th-age', '7th-sea', 'a-game-of-thrones', 'adnd', 'adnd-2e', 'adventurer-conqueror-king', 'all-flesh-must-be-eaten', 'anima-beyond-fantasy', 'apocalypse-world', 'ars-magica', 'ars-magica-5', 'basic-role-playing', 'battlestar-galactica', 'battletech', 'black-crusade', 'buck-rogers', 'burning-wheel', 'cadillacs-and-dinosaurs', 'call-of-cthulhu', 'call-of-cthulhu-d20', 'changeling-dreaming', 'changeling-lost', 'coda', 'continuum', 'cortex', 'cortex-plus', 'cyberpunk-2020', 'd20-modern', 'd6-system', 'dangerous-journeys', 'dark-ages', 'dark-heresy', 'deadlands', 'deathwatch', 'delta-green', 'diaspora', 'dictionary-of-mu', 'dnd-becmi', 'dnd-bx', 'dnd-next', 'dogs-in-the-vineyard', 'dread', 'dresden-files', 'dungeon-world', 'earthdawn', 'eclipse-phase', 'en-garde', 'exalted', 'fallout-pnp-rpg', 'fate', 'fate-core', 'fear-itself', 'feng-shui', 'fiasco', 'freemarket', 'fudge', 'gamma-world', 'geist-sin-eaters', 'genius-transgression', 'golarion', 'gumshoe', 'gurps', 'gurps-4e', 'heavygear', 'heresy-engine', 'hero-system', 'heroquest', 'hollow-earth-expedition', 'hunter-vigil', 'in-a-wicked-age', 'in-nomine', 'interface-zero', 'jade-regent', 'kult', 'l5r', 'l5r-4e', 'labyrinth-lord', 'lady-blackbird', 'laundry', 'legend', 'legends-of-anglerre', 'leverage', 'little-fears', 'lotfp', 'mage-ascension', 'mage-awakening', 'maid', 'marvel-heroic', 'mazes-and-minotaurs', 'mechwarrior-4e', 'microscope', 'mini-six', 'mouse-guard', 'mutant-city-blues', 'mutants-and-masterminds', 'natural-weapon', 'nobilis', 'nwod', 'odnd', 'over-the-edge', 'palladium-system', 'paranoia', 'reign', 'rogue-trader', 'rolemaster', 'runequest', 'savage-worlds', 'savage-worlds-fantasy', 'serenity', 'shadowrun', 'shadowrun-sr4', 'shock', 'sifrp', 'spirit-of-the-century', 'spycraft', 'star-trek', 'star-wars', 'star-wars-d20', 'star-wars-saga-edition', 'storyteller-system', 'storytelling-system', 'sword-noir', 'tekumel', 'tftfv', 'the-dark-eye', 'the-esoterrorists', 'the-multiverse-rpg', 'the-one-ring', 'the-riddle-of-steel', 'tolkien', 'torg', 'toward-one', 'trail-of-cthulhu', 'traveller', 'tremulus', 'tsoy', 'ubiquity', 'unisystem', 'universalis', 'vampire-masquerade', 'vampire-requiem', 'warp', 'werewolf-forsaken', 'wfrp', 'wfrp-1e', 'wfrp-2e', 'wfrp-3e', 'wh40k', 'wild-talents', 'world-of-darkness', 'wraith-oblivion', 'wraith-orpheus')
                            )
             OR posts.parentid in  (SELECT posttags.postid
                               FROM tags JOIN posttags ON (tags.id = posttags.tagid)
                              WHERE tagname in ( '13th-age', '7th-sea', 'a-game-of-thrones', 'adnd', 'adnd-2e', 'adventurer-conqueror-king', 'all-flesh-must-be-eaten', 'anima-beyond-fantasy', 'apocalypse-world', 'ars-magica', 'ars-magica-5', 'basic-role-playing', 'battlestar-galactica', 'battletech', 'black-crusade', 'buck-rogers', 'burning-wheel', 'cadillacs-and-dinosaurs', 'call-of-cthulhu', 'call-of-cthulhu-d20', 'changeling-dreaming', 'changeling-lost', 'coda', 'continuum', 'cortex', 'cortex-plus', 'cyberpunk-2020', 'd20-modern', 'd6-system', 'dangerous-journeys', 'dark-ages', 'dark-heresy', 'deadlands', 'deathwatch', 'delta-green', 'diaspora', 'dictionary-of-mu', 'dnd-becmi', 'dnd-bx', 'dnd-next', 'dogs-in-the-vineyard', 'dread', 'dresden-files', 'dungeon-world', 'earthdawn', 'eclipse-phase', 'en-garde', 'exalted', 'fallout-pnp-rpg', 'fate', 'fate-core', 'fear-itself', 'feng-shui', 'fiasco', 'freemarket', 'fudge', 'gamma-world', 'geist-sin-eaters', 'genius-transgression', 'golarion', 'gumshoe', 'gurps', 'gurps-4e', 'heavygear', 'heresy-engine', 'hero-system', 'heroquest', 'hollow-earth-expedition', 'hunter-vigil', 'in-a-wicked-age', 'in-nomine', 'interface-zero', 'jade-regent', 'kult', 'l5r', 'l5r-4e', 'labyrinth-lord', 'lady-blackbird', 'laundry', 'legend', 'legends-of-anglerre', 'leverage', 'little-fears', 'lotfp', 'mage-ascension', 'mage-awakening', 'maid', 'marvel-heroic', 'mazes-and-minotaurs', 'mechwarrior-4e', 'microscope', 'mini-six', 'mouse-guard', 'mutant-city-blues', 'mutants-and-masterminds', 'natural-weapon', 'nobilis', 'nwod', 'odnd', 'over-the-edge', 'palladium-system', 'paranoia', 'reign', 'rogue-trader', 'rolemaster', 'runequest', 'savage-worlds', 'savage-worlds-fantasy', 'serenity', 'shadowrun', 'shadowrun-sr4', 'shock', 'sifrp', 'spirit-of-the-century', 'spycraft', 'star-trek', 'star-wars', 'star-wars-d20', 'star-wars-saga-edition', 'storyteller-system', 'storytelling-system', 'sword-noir', 'tekumel', 'tftfv', 'the-dark-eye', 'the-esoterrorists', 'the-multiverse-rpg', 'the-one-ring', 'the-riddle-of-steel', 'tolkien', 'torg', 'toward-one', 'trail-of-cthulhu', 'traveller', 'tremulus', 'tsoy', 'ubiquity', 'unisystem', 'universalis', 'vampire-masquerade', 'vampire-requiem', 'warp', 'werewolf-forsaken', 'wfrp', 'wfrp-1e', 'wfrp-2e', 'wfrp-3e', 'wh40k', 'wild-talents', 'world-of-darkness', 'wraith-oblivion', 'wraith-orpheus')
                              ) )                          
            AND posts.creationdate between '29-APR-2013' and '31-MAY-2013'
            AND posts.score >= 10
          UNION
         SELECT userid, 2 as points
           FROM badges
          WHERE badges.name IN ('Announcer', 'Booster', 'Publicist')
            AND badges.date BETWEEN '29-APR-2013' AND '31-MAY-2013'      
     ) a 
  JOIN users ON (a.userid = users.id)
GROUP BY displayname;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results