Total Moderators vs. Total Users Active on [Site]

1

Please login or register to vote for this query.

(click on this box to dismiss)

Pulls the total active moderators and the total active users on [site]. Moderator list includes all moderators across the entire network as found on <https://stackexchange.com/about/moderators>. "Active" is defined liberally as "user has accessed the site in the last 6 months".

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

CREATE TABLE #mods (site nvarchar(50), userid int, username nvarchar(50));INSERT INTO #mods VALUES ('StackExchange.3dprinting', 5740, '0scar'), ('StackExchange.3dprinting', 4762, 'Greenonline'), ('StackExchange.3dprinting', 2146, 'StarWind0'), ('StackExchange.academia', 7734, 'Wrzlprmft'), ('StackExchange.academia', 20058, 'Massimo Ortolano'), ('StackExchange.academia', 79875, 'cag51'), ('StackExchange.academia', 73, 'eykanal'), ('StackExchange.ham', 76, 'Kevin Reid AG6YO'), ('StackExchange.ham', 8717, 'Mike Waters'), ('StackExchange.ham', 873, 'Scott Earle'), ('StackExchange.android', 16575, 'Izzy'), ('StackExchange.android', 96277, 'Firelord'), ('StackExchange.android', 44325, 'Andrew T.'), ('StackExchange.android', 10, 'Bryan Denny'), ('StackExchange.anime', 2516, 'Aki Tanaka'), ('StackExchange.anime', 1458, 'Dimitri mx'), ('StackExchange.anime', 63, 'кяαzєя'), ('StackExchange.arduino', 4143, 'Majenko'), ('StackExchange.arduino', 37622, 'Juraj'), ('StackExchange.arduino', 10794, 'Nick Gammon'), ('StackExchange.gaming', 8350, 'Wipqozn'), ('StackExchange.gaming', 28182, 'Robotnik'), ('StackExchange.gaming', 143571, 'Wrigglenite'), ('StackExchange.gaming', 20306, 'Unionhawk'), ('StackExchange.gaming', 127901, 'Dragonrage'), ('StackExchange.ai', 1641, 'Dennis Soemers'), ('StackExchange.ai', 1671, 'DukeZhou'), ('StackExchange.ai', 16909, 'John Doucette'), ('StackExchange.ai', 2444, 'nbro'), ('StackExchange.crafts', 30, 'Erica'), ('StackExchange.crafts', 6388, 'Joachim'), ('StackExchange.crafts', 8260, 'Lyssagal'), ('StackExchange.apple', 5472, 'bmike'), ('StackExchange.apple', 9388, 'Daniel'), ('StackExchange.apple', 292, 'Ian C.'), ('StackExchange.apple', 9058, 'nohillside'), ('StackExchange.apple', 37797, 'grg'), ('StackExchange.apple', 168832, 'Monomeeth'), ('StackExchange.apple', 121968, 'Glorfindel'), ('StackExchange.patents', 17003, 'Eric S'), ('StackExchange.patents', 3076, 'George White'), ('StackExchange.ubuntu', 449, 'Oli'), ('StackExchange.ubuntu', 14356, 'fossfreedom'), ('StackExchange.ubuntu', 25798, 'jokerdino'), ('StackExchange.ubuntu', 59676, 'Mitch'), ('StackExchange.ubuntu', 10616, 'Thomas Ward'), ('StackExchange.ubuntu', 367990, 'Byte Commander'), ('StackExchange.ubuntu', 527764, 'Zanna'), ('StackExchange.ubuntu', 264781, 'Ravexina'), ('StackExchange.ubuntu', 41, 'Marco Ceppi'), ('StackExchange.astronomy', 6, 'called2voyage'), ('StackExchange.astronomy', 36644, 'Connor Garcia'), ('StackExchange.astronomy', 38, 'Donald.McLean'), ('StackExchange.astronomy', 2153, 'HDE 226868'), ('StackExchange.aviation', 65, 'Farhan'), ('StackExchange.aviation', 1467, 'Federico'), ('StackExchange.aviation', 100, 'Jamiec'), ('StackExchange.aviation', 1696, 'fooot'), ('StackExchange.beer', 5078, 'Jamie Eltringham'), ('StackExchange.beer', 37, 'Xander'), ('StackExchange.hermeneutics', 2757, 'curiousdannii'), ('StackExchange.hermeneutics', 13311, 'Steve Taylor'), ('StackExchange.hermeneutics', 68, 'Jon Ericson'), ('StackExchange.bicycles', 4239, 'jimchristie'), ('StackExchange.bicycles', 19705, 'Criggie'), ('StackExchange.bicycles', 76, 'freiheit'), ('StackExchange.bicycles', 213, 'Gary.Ray'), ('StackExchange.bioinformatics', 77, 'Devon Ryan'), ('StackExchange.bioinformatics', 73, 'gringer'), ('StackExchange.bioinformatics', 57, 'Kamil S Jaron'), ('StackExchange.biology', 5144, 'Chris'), ('StackExchange.biology', 9943, 'AliceD'), ('StackExchange.biology', 16866, 'theforestecologist'), ('StackExchange.biology', 27148, 'Bryan Krause'), ('StackExchange.bitcoin', 48884, 'Andrew Chow'), ('StackExchange.bitcoin', 51948, 'MeshCollider'), ('StackExchange.bitcoin', 5406, 'Murch'), ('StackExchange.blender', 599, 'gandalf3'), ('StackExchange.blender', 19307, 'Duarte Farrajota Ramos'), ('StackExchange.blender', 74827, 'Robert Gützkow'), ('StackExchange.blender', 15924, 'Timaroberts'), ('StackExchange.boardgames', 409, 'Cascabel'), ('StackExchange.boardgames', 2537, 'murgatroid99'), ('StackExchange.boardgames', 40, 'Pat Ludwig'), ('StackExchange.bricks', 132, 'Ambo100'), ('StackExchange.bricks', 708, 'jncraton'), ('StackExchange.bricks', 56, 'Zhaph - Ben Duguid'), ('StackExchange.buddhism', 43, 'Andrei Volkov'), ('StackExchange.buddhism', 254, 'ChrisW'), ('StackExchange.buddhism', 471, 'ruben2020'), ('StackExchange.cardano', 281, 'gRebel'), ('StackExchange.cardano', 28, 'Marek Mahut - StakeNuts'), ('StackExchange.cardano', 934, 'Matthias Sieber'), ('StackExchange.chemistry', 4945, 'Martin - マーチン'), ('StackExchange.chemistry', 16683, 'orthocresol'), ('StackExchange.chemistry', 41328, 'andselisk'), ('StackExchange.chemistry', 402, 'Melanie Shebel'), ('StackExchange.chemistry', 69830, 'Buck Thorn'), ('StackExchange.chemistry', 865, 'Todd Minehardt'), ('StackExchange.chess', 12, 'Andrew'), ('StackExchange.chess', 4418, 'Brian Towers'), ('StackExchange.chess', 7297, 'Glorfindel'), ('StackExchange.chinese', 8099, 'Becky 李蓓'), ('StackExchange.chinese', 13882, 'Tang Ho'), ('StackExchange.chinese', 4136, 'Mou某'), ('StackExchange.christianity', 4, 'Peter Turner'), ('StackExchange.christianity', 6071, 'curiousdannii'), ('StackExchange.christianity', 25495, 'Ken Graham'), ('StackExchange.christianity', 68, 'Mason Wheeler'), ('StackExchange.civicrm', 225, 'Aidan'), ('StackExchange.civicrm', 40, 'Joe Murray'), ('StackExchange.civicrm', 96, 'petednz - fuzion'), ('StackExchange.codegolf', 76162, 'Jo King'), ('StackExchange.codegolf', 68942, 'hyper-neutrino'), ('StackExchange.codegolf', 56656, 'Wheat Wizard'), ('StackExchange.codegolf', 3808, 'Doorknob'), ('StackExchange.codereview', 18427, 'Malachi'), ('StackExchange.codereview', 42401, 'Peilonrayz'), ('StackExchange.codereview', 120114, 'Sᴀᴍ Onᴇᴌᴀ'), ('StackExchange.codereview', 52915, 'Mast'), ('StackExchange.codereview', 22222, 'Jamal'), ('StackExchange.coffee', 127, 'fredley'), ('StackExchange.coffee', 262, 'hoc_age'), ('StackExchange.coffee', 6506, 'JJJ'), ('StackExchange.coffee', 1118, 'Stephie'), ('StackExchange.moderators', 105, 'ChrisF'), ('StackExchange.moderators', 11, 'AJ Henderson'), ('StackExchange.moderators', 78, 'Andy'), ('StackExchange.scicomp', 20688, 'Anton Menshov'), ('StackExchange.scicomp', 9667, 'nicoguaro'), ('StackExchange.scicomp', 549, 'Paul'), ('StackExchange.computergraphics', 482, 'luser droog'), ('StackExchange.computergraphics', 13095, 'wychmaster'), ('StackExchange.cs', 755, 'D.W.'), ('StackExchange.cs', 65339, 'Discrete lizard'), ('StackExchange.cs', 98, 'Raphael'), ('StackExchange.cseducators', 27, 'Ben I.'), ('StackExchange.cseducators', 58, 'thesecretmaster'), ('StackExchange.conlang', 142, 'jk - Reinstate Monica'), ('StackExchange.conlang', 113, 'curiousdannii'), ('StackExchange.craftcms', 103, 'Anna_MediaGirl'), ('StackExchange.craftcms', 45, 'Lindsey D'), ('StackExchange.craftcms', 22, 'Matt Stein'), ('StackExchange.stats', 919, 'whuber'), ('StackExchange.stats', 17230, 'Scortchi - Reinstate Monica'), ('StackExchange.stats', 35989, 'Tim'), ('StackExchange.stats', 11887, 'kjetil b halvorsen'), ('StackExchange.stats', 22311, 'Sycorax'), ('StackExchange.crypto', 23623, 'SEJPM'), ('StackExchange.crypto', 1172, 'Maarten Bodewes'), ('StackExchange.crypto', 555, 'fgrieu'), ('StackExchange.datascience', 29575, 'Stephen Rauch'), ('StackExchange.datascience', 23305, 'oW_'), ('StackExchange.datascience', 11097, 'Dawny33'), ('StackExchange.dba', 1192, 'Paul White'), ('StackExchange.dba', 10832, 'Hannah Vernon'), ('StackExchange.dba', 171, 'jcolebrand'), ('StackExchange.devops', 323, 'Peter Turner'), ('StackExchange.devops', 40, 'Pierre.Vriens'), ('StackExchange.devops', 4328, 'Preston Martin'), ('StackExchange.drones', 97, 'ifconfig'), ('StackExchange.drones', 170, 'Jacob B'), ('StackExchange.drupal', 835, 'mpdonadio'), ('StackExchange.drupal', 2800, 'Clive'), ('StackExchange.drupal', 199, 'apaderno'), ('StackExchange.earthscience', 543, 'f.thorpe'), ('StackExchange.earthscience', 6, 'gerrit'), ('StackExchange.earthscience', 20, 'hichris123'), ('StackExchange.ebooks', 1202, 'Daniel'), ('StackExchange.ebooks', 142, 'Jason Down'), ('StackExchange.ebooks', 106, 'mau'), ('StackExchange.economics', 15517, '1muflon1'), ('StackExchange.economics', 8815, 'EconJohn'), ('StackExchange.economics', 4251, 'Kitsune Cavalry'), ('StackExchange.electronics', 96810, 'Voltage Spike'), ('StackExchange.electronics', 3288, 'Russell McMahon'), ('StackExchange.electronics', 101852, 'SamGibson'), ('StackExchange.elementaryos', 3018, 'Maccer'), ('StackExchange.elementaryos', 26, 'Lewis Goddard'), ('StackExchange.emacs', 591, 'Aaron Hall'), ('StackExchange.emacs', 8406, 'Joe Corneli'), ('StackExchange.emacs', 253, 'Dan'), ('StackExchange.engineering', 33, 'hazzey'), ('StackExchange.engineering', 1832, 'Wasabi'), ('StackExchange.english', 300, 'RegDwigнt'), ('StackExchange.english', 8360, 'Kit Z. Fox'), ('StackExchange.english', 18696, 'Andrew Leach'), ('StackExchange.english', 3119, 'Yoichi Oishi'), ('StackExchange.english', 3559, 'Matt E. Эллен'), ('StackExchange.english', 2085, 'tchrist'), ('StackExchange.english', 39, 'nohat'), ('StackExchange.ell', 36187, 'Em.'), ('StackExchange.ell', 18673, 'Glorfindel'), ('StackExchange.ell', 61125, 'Eddie Kal'), ('StackExchange.ell', 113, 'J.R.'), ('StackExchange.eosio', 1232, 'Phillip Hamnett - EOS42'), ('StackExchange.eosio', 15, 'TeeAttack42'), ('StackExchange.esperanto', 1576, 'das-g'), ('StackExchange.esperanto', 13, 'Neil Roberts'), ('StackExchange.ethereum', 2021, 'Badr Bellaj'), ('StackExchange.ethereum', 2124, 'Ismael'), ('StackExchange.ethereum', 42, 'eth'), ('StackExchange.expatriates', 658, 'ouflak'), ('StackExchange.expatriates', 541, 'Scott Earle'), ('StackExchange.expatriates', 25, 'SztupY'), ('StackExchange.expressionengine', 22, 'Alex Kendrick'), ('StackExchange.expressionengine', 28, 'Anna_MediaGirl'), ('StackExchange.freelancing', 75, 'Canadian Luke'), ('StackExchange.french', 14093, 'Reyedy'), ('StackExchange.french', 11052, 'Tsundoku'), ('StackExchange.french', 12688, 'Luke Sawczak'), ('StackExchange.gamedev', 7191, 'MichaelHouse'), ('StackExchange.gamedev', 40264, 'Vaillancourt'), ('StackExchange.gamedev', 39518, 'DMGregory'), ('StackExchange.gamedev', 12670, 'Almo'), ('StackExchange.gamedev', 41345, 'Evorlor'), ('StackExchange.gamedev', 14, 'Jesse Dorsey'), ('StackExchange.gardening', 499, 'kevinskio'), ('StackExchange.gardening', 26, 'Niall C.'), ('StackExchange.gardening', 7456, 'Stephie'), ('StackExchange.genealogy', 6485, 'ColeValleyGirl'), ('StackExchange.genealogy', 1107, 'Harry V.'), ('StackExchange.genealogy', 1006, 'Jan Murphy'), ('StackExchange.genealogy', 19, 'PolyGeo'), ('StackExchange.gis', 276, 'Mapperz'), ('StackExchange.gis', 187, 'underdark'), ('StackExchange.gis', 79, 'Ian Turton'), ('StackExchange.gis', 115, 'PolyGeo'), ('StackExchange.gis', 8104, 'Aaron'), ('StackExchange.gis', 7424, 'Fezter'), ('StackExchange.gis', 64785, 'Midavalo'), ('StackExchange.german', 1696, 'guidot'), ('StackExchange.german', 15393, 'jonathan.scholbach'), ('StackExchange.german', 2594, 'Wrzlprmft'), ('StackExchange.graphicdesign', 19174, 'Wrzlprmft'), ('StackExchange.graphicdesign', 18168, 'curious'), ('StackExchange.graphicdesign', 41100, 'PieBie'), ('StackExchange.hardwarerecs', 57, 'Andy'), ('StackExchange.hardwarerecs', 8, 'ArtOfCode'), ('StackExchange.hinduism', 36, 'Keshav Srinivasan'), ('StackExchange.hinduism', 277, 'Pandya'), ('StackExchange.hinduism', 3500, 'The Destroyer'), ('StackExchange.hinduism', 647, 'TheLittleNaruto'), ('StackExchange.history', 21290, 'Robert Columbia'), ('StackExchange.history', 1401, 'MCW'), ('StackExchange.history', 4935, 'Semaphore'), ('StackExchange.history', 771, 'T.E.D.'), ('StackExchange.hsm', 26, 'Danu'), ('StackExchange.hsm', 62, 'HDE 226868'), ('StackExchange.diy', 194, 'ChrisF'), ('StackExchange.diy', 2196, 'BMitch'), ('StackExchange.diy', 22, 'Niall C.'), ('StackExchange.diy', 7367, 'Michael Karas'), ('StackExchange.homebrew', 14765, 'farmersteve'), ('StackExchange.homebrew', 12182, 'Mr_road'), ('StackExchange.homebrew', 12609, 'thesquaregroot'), ('StackExchange.security', 836, 'Jeff Ferland'), ('StackExchange.security', 6253, 'schroeder'), ('StackExchange.security', 33, 'AviD'), ('StackExchange.security', 485, 'Rory Alsop'), ('StackExchange.iot', 49, 'anonymous2'), ('StackExchange.iot', 54, 'Ghanima'), ('StackExchange.iot', 78, 'Helmar'), ('StackExchange.interpersonal', 4550, 'avazula'), ('StackExchange.interpersonal', 29, 'A J'), ('StackExchange.interpersonal', 3171, 'Em C'), ('StackExchange.interpersonal', 33, 'John'), ('StackExchange.interpersonal', 1599, 'Tinkeringbell'), ('StackExchange.iota', 19, 'aboose'), ('StackExchange.iota', 134, 'mihi'), ('StackExchange.iota', 364, 'Tobi MZ'), ('StackExchange.islam', 2871, 'Farhan'), ('StackExchange.islam', 22, 'goldPseudo'), ('StackExchange.islam', 13438, 'Medi1Saif'), ('StackExchange.italian', 707, 'Charo'), ('StackExchange.italian', 1818, 'Denis Nardin'), ('StackExchange.italian', 70, 'egreg'), ('StackExchange.japanese', 1628, 'Earthliŋ'), ('StackExchange.japanese', 542, 'Flaw'), ('StackExchange.japanese', 9831, 'Chocolate'), ('StackExchange.joomla', 69, 'Harald Leithner'), ('StackExchange.joomla', 12352, 'mickmackusa'), ('StackExchange.joomla', 13472, 'pe7er'), ('StackExchange.korean', 91, 'user17915'), ('StackExchange.korean', 26, 'Vladhagen'), ('StackExchange.languagelearning', 91, 'fi12'), ('StackExchange.languagelearning', 46, 'Tom Au'), ('StackExchange.languagelearning', 800, 'Tsundoku'), ('StackExchange.latin', 30, 'Cerberus'), ('StackExchange.latin', 78, 'cmw'), ('StackExchange.latin', 406, 'Draconis'), ('StackExchange.latin', 79, 'Joonas Ilmavirta'), ('StackExchange.law', 480, 'Pat W.'), ('StackExchange.law', 344, 'Dale M'), ('StackExchange.law', 10, 'feetwet'), ('StackExchange.lifehacks', 4198, 'BrettFromLA'), ('StackExchange.lifehacks', 6973, 'Chenmunka'), ('StackExchange.lifehacks', 20, 'michaelpri'), ('StackExchange.linguistics', 111, 'Alenanno'), ('StackExchange.linguistics', 13238, 'lemontree'), ('StackExchange.linguistics', 126, 'prash'), ('StackExchange.literature', 11, 'Gallifreyan'), ('StackExchange.literature', 58, 'Mithical'), ('StackExchange.literature', 17, 'Rand al''Thor'), ('StackExchange.literature', 2191, 'Tsundoku'), ('StackExchange.magento', 50, 'Sander Mangel'), ('StackExchange.magento', 4564, 'Amit Bera'), ('StackExchange.magento', 146, 'Marius'), ('StackExchange.martialarts', 548, 'JohnP'), ('StackExchange.martialarts', 5961, 'mattm'), ('StackExchange.martialarts', 70, 'slugster'), ('StackExchange.mathematica', 5, 'rm -rf'), ('StackExchange.mathematica', 5478, 'Kuba'), ('StackExchange.mathematica', 187, 'halirutan'), ('StackExchange.mathematica', 50, 'J. M.''s torpor'), ('StackExchange.math', 9754, 'davidlowryduda'), ('StackExchange.math', 13854, 'robjohn'), ('StackExchange.math', 21674, 'Michael Greinecker'), ('StackExchange.math', 12952, 'Alexander Gruber'), ('StackExchange.math', 83702, 'Daniel Fischer'), ('StackExchange.math', 23350, 'Pedro Tamaroff'), ('StackExchange.math', 85306, 'quid'), ('StackExchange.math', 622, 'Asaf Karagila'), ('StackExchange.math', 59234, 'Aloizio Macedo'), ('StackExchange.math', 468350, 'Xander Henderson'), ('StackExchange.matheducators', 11, 'Chris Cunningham'), ('StackExchange.matheducators', 143, 'quid'), ('StackExchange.matheducators', 60, 'Sue VanHattum'), ('StackExchange.mathoverflow', 2926, 'Todd Trimble'), ('StackExchange.mathoverflow', 2362, 'Tim Campion'), ('StackExchange.mathoverflow', 28104, 'Stefan Kohl'), ('StackExchange.mathoverflow', 7206, 'Asaf Karagila'), ('StackExchange.mathoverflow', 66, 'Ben Webster'), ('StackExchange.mathoverflow', 2000, 'François G. Dorais'), ('StackExchange.mathoverflow', 121, 'S. Carnahan'), ('StackExchange.materials', 24, 'Camps'), ('StackExchange.materials', 88, 'Thomas'), ('StackExchange.materials', 7, 'Tyberius'), ('StackExchange.health', 805, 'Carey Gregory'), ('StackExchange.health', 64, 'JohnP'), ('StackExchange.health', 26, 'michaelpri'), ('StackExchange.meta', 59303, 'ChrisF'), ('StackExchange.meta', 295232, 'Glorfindel'), ('StackExchange.meta', 135565, 'Journeyman Geek'), ('StackExchange.meta', 369802, 'Tinkeringbell'), ('StackExchange.judaism', 759, 'Double AA'), ('StackExchange.judaism', 2, 'Isaac Moses'), ('StackExchange.judaism', 170, 'msh210'), ('StackExchange.monero', 7493, 'jtgrassie'), ('StackExchange.monero', 44, 'dEBRUYNE'), ('StackExchange.garage', 4152, 'Pᴀᴜʟsᴛᴇʀ2'), ('StackExchange.garage', 373, 'Nick C'), ('StackExchange.garage', 57, 'Bob Cross'), ('StackExchange.movies', 49, 'Napoleon Wilson'), ('StackExchange.movies', 27264, 'A J'), ('StackExchange.movies', 40, 'iandotkelly'), ('StackExchange.musicfans', 7, 'Dom'), ('StackExchange.musicfans', 27, 'Donald.McLean'), ('StackExchange.musicfans', 53, 'Johnny Bones'), ('StackExchange.music', 7222, 'Dom'), ('StackExchange.music', 21766, 'Richard'), ('StackExchange.music', 104, 'Doktor Mayhem'), ('StackExchange.mythology', 183, 'HDE 226868'), ('StackExchange.mythology', 108, 'Semaphore'), ('StackExchange.mythology', 57, 'yannis'), ('StackExchange.networkengineering', 509, 'Teun Vink'), ('StackExchange.networkengineering', 8499, 'Ron Maupin'), ('StackExchange.networkengineering', 33, 'YLearn'), ('StackExchange.opendata', 90, 'albert'), ('StackExchange.opendata', 70, 'Patrick Hoefler'), ('StackExchange.opendata', 1511, 'philshem'), ('StackExchange.opensource', 50, 'apsillers'), ('StackExchange.opensource', 98, 'ArtOfCode'), ('StackExchange.opensource', 458, 'MadHatter'), ('StackExchange.or', 36, 'EhsanK'), ('StackExchange.or', 38, 'LarrySnyder610'), ('StackExchange.or', 123, 'TheSimpliFire'), ('StackExchange.parenting', 4348, 'SomeShinyObject'), ('StackExchange.parenting', 11249, 'Stephie'), ('StackExchange.parenting', 316, 'Rory Alsop'), ('StackExchange.money', 187, 'JTP - Apologise to Monica'), ('StackExchange.money', 149, 'JohnFx'), ('StackExchange.money', 366, 'GS - Apologise to Monica'), ('StackExchange.pets', 12501, 'Elmy'), ('StackExchange.pets', 5456, 'Harry V.'), ('StackExchange.pets', 17671, 'lila'), ('StackExchange.philosophy', 17209, 'Philip Klöcking'), ('StackExchange.philosophy', 29361, 'Geoffrey Thomas'), ('StackExchange.philosophy', 81, 'Joseph Weissman'), ('StackExchange.photography', 4191, 'MikeW'), ('StackExchange.photography', 11392, 'AJ Henderson'), ('StackExchange.photography', 11371, 'Philip Kendall'), ('StackExchange.photography', 11924, 'scottbb'), ('StackExchange.fitness', 8828, 'Alec'), ('StackExchange.fitness', 3736, 'JohnP'), ('StackExchange.physics', 2451, 'Qmechanic'), ('StackExchange.physics', 44126, 'rob'), ('StackExchange.physics', 50583, 'ACuriousMind'), ('StackExchange.physics', 106502, 'Chris'), ('StackExchange.poker', 3538, 'Grinch91'), ('StackExchange.poker', 309, 'Radu Murzea'), ('StackExchange.poker', 88, 'Toby Booth'), ('StackExchange.politics', 28994, 'CDJB'), ('StackExchange.politics', 18862, 'JJJ'), ('StackExchange.politics', 3135, 'Philipp'), ('StackExchange.politics', 101, 'yannis'), ('StackExchange.portuguese', 153, 'Jorge B.'), ('StackExchange.portuguese', 2764, 'stafusa'), ('StackExchange.portuguese', 38, 'tchrist'), ('StackExchange.pm', 430, 'Tiago Cardoso'), ('StackExchange.pm', 4271, 'Todd A. Jacobs'), ('StackExchange.cogsci', 6983, 'AliceD'), ('StackExchange.cogsci', 7001, 'Arnon Weinberg'), ('StackExchange.cogsci', 52, 'Jeromy Anglim'), ('StackExchange.cogsci', 21, 'Steven Jeuris'), ('StackExchange.puzzling', 11876, 'Deusovi'), ('StackExchange.puzzling', 4421, 'GentlePurpleRain'), ('StackExchange.puzzling', 19114, 'Gareth McCaughan'), ('StackExchange.puzzling', 30633, 'Rubio'), ('StackExchange.quant', 29443, 'Attack68'), ('StackExchange.quant', 848, 'Bob Jansen'), ('StackExchange.quant', 70, 'olaker'), ('StackExchange.quantumcomputing', 55, 'glS'), ('StackExchange.quantumcomputing', 91, 'karatechop'), ('StackExchange.quantumcomputing', 23, 'Mithrandir24601'), ('StackExchange.raspberrypi', 19949, 'Ghanima'), ('StackExchange.raspberrypi', 8496, 'Jacobm001'), ('StackExchange.raspberrypi', 24296, 'Darth Vader'), ('StackExchange.raspberrypi', 5538, 'goldilocks'), ('StackExchange.retrocomputing', 276, 'Chenmunka'), ('StackExchange.retrocomputing', 107, 'Matt Lacey'), ('StackExchange.retrocomputing', 278, 'wizzwizz4'), ('StackExchange.reverseengineering', 245, '0xC0000022L'), ('StackExchange.reverseengineering', 60, 'Igor Skochinsky'), ('StackExchange.reverseengineering', 18317, 'julian'), ('StackExchange.robotics', 134, 'Andrew'), ('StackExchange.robotics', 110, 'Ben'), ('StackExchange.robotics', 37, 'Mark Booth'), ('StackExchange.rpg', 28591, 'Rubiksmoose'), ('StackExchange.rpg', 33569, 'V2Blast'), ('StackExchange.rpg', 52137, 'Someone_Evil'), ('StackExchange.rpg', 48759, 'linksassin'), ('StackExchange.russian', 3680, 'Dmitry'), ('StackExchange.russian', 134, 'Quassnoi'), ('StackExchange.russian', 242, 'shabunc'), ('StackExchange.salesforce', 2995, 'Adrian Larson'), ('StackExchange.salesforce', 46017, 'David Reed'), ('StackExchange.salesforce', 78, 'Matt Lacey'), ('StackExchange.scifi', 3804, 'AncientSwordRage'), ('StackExchange.scifi', 31394, 'Rand al''Thor'), ('StackExchange.scifi', 31936, 'Null'), ('StackExchange.scifi', 58193, 'TheLethalCarrot'), ('StackExchange.cooking', 4638, 'rumtscho'), ('StackExchange.cooking', 1672, 'Cascabel'), ('StackExchange.cooking', 20183, 'Jolenealaska'), ('StackExchange.cooking', 28879, 'Stephie'), ('ServerFault', 3038, 'sysadmin1138'), ('ServerFault', 1375, 'womble'), ('ServerFault', 6177, 'Ward - Reinstate Monica'), ('ServerFault', 256639, 'yagmoth555'), ('StackExchange.sharepoint', 62, 'SPDoctor'), ('StackExchange.sharepoint', 6382, 'Benny Skogberg'), ('StackExchange.sharepoint', 21563, 'Waqas Sarwar MVP'), ('StackExchange.sharepoint', 53462, 'Mohamed El-Qassas MVP'), ('StackExchange.dsp', 8202, 'jojek'), ('StackExchange.dsp', 35, 'datageist'), ('StackExchange.dsp', 80, 'Peter K.'), ('StackExchange.sitecore', 135, 'jammykam'), ('StackExchange.sitecore', 73, 'Mark Cassidy'), ('StackExchange.sitecore', 70, 'Richard Seal'), ('StackExchange.skeptics', 5167, 'Jamiec'), ('StackExchange.skeptics', 25597, 'tim'), ('StackExchange.skeptics', 11643, 'fredsbend'), ('StackExchange.skeptics', 23, 'Oddthinking'), ('StackExchange.programmers', 4, 'Thomas Owens'), ('StackExchange.programmers', 25476, 'maple_shaft'), ('StackExchange.programmers', 47, 'ChrisF'), ('StackExchange.sqa', 5574, 'alecxe'), ('StackExchange.sqa', 65, 'corsiKa'), ('StackExchange.sqa', 422, 'Kate Paulk'), ('StackExchange.softwarerecs', 140, 'Nicolas Raoul'), ('StackExchange.softwarerecs', 185, 'Izzy'), ('StackExchange.softwarerecs', 8503, 'RockPaperLz- Mask it or Casket'), ('StackExchange.sound', 7174, 'AJ Henderson'), ('StackExchange.sound', 7016, 'Rory Alsop'), ('StackExchange.space', 58, 'called2voyage'), ('StackExchange.space', 33, 'gerrit'), ('StackExchange.space', 25, 'PearsonArtPhoto'), ('StackExchange.spanish', 12637, 'Charlie'), ('StackExchange.spanish', 13538, 'Glorfindel'), ('StackExchange.spanish', 24236, 'wimi'), ('StackExchange.sports', 6232, 'Joe'), ('StackExchange.sports', 9319, 'Nij'), ('StackExchange.sports', 6126, 'Philip Kendall'), ('stackapps', 34061, 'Glorfindel'), ('stackapps', 18722, 'rene'), ('stackapps', 4746, 'Tim Stone'), ('StackOverflow', 13531, 'Michael Myers'), ('StackOverflow', 50049, 'Tim Post'), ('StackOverflow', 106224, 'BoltClock'), ('StackOverflow', 19679, 'Brad Larson'), ('StackOverflow', 59303, 'ChrisF'), ('StackOverflow', 168175, 'Flexo'), ('StackOverflow', 707111, 'Ry-'), ('StackOverflow', 256196, 'Bohemian'), ('StackOverflow', 229044, 'meagar'), ('StackOverflow', 100297, 'Martijn Pieters'), ('StackOverflow', 1252759, 'Jon Clements'), ('StackOverflow', 3093387, 'josliber'), ('StackOverflow', 1849664, 'Undo'), ('StackOverflow', 476, 'deceze'), ('StackOverflow', 541136, 'Aaron Hall'), ('StackOverflow', 4099593, 'Bhargav Rao'), ('StackOverflow', 189134, 'Andy'), ('StackOverflow', 366904, 'Cody Gray'), ('StackOverflow', 584192, 'Samuel Liew'), ('StackOverflow', 563532, 'Rob'), ('StackOverflow', 3002139, 'Baum mit Augen'), ('StackOverflow', 6451573, 'Jean-François Fabre'), ('StackOverflow', 3773011, 'Makyen'), ('StackOverflow', 2370483, 'Machavity'), ('StackOverflow.br', 3117, 'Math'), ('StackOverflow.br', 129, 'Sergio'), ('StackOverflow.br', 101, 'Maniero'), ('StackOverflow.br', 91, 'rray'), ('StackOverflow.br', 70, 'Bacco'), ('StackOverflow.br', 3635, 'Guilherme Nascimento'), ('StackOverflow.br', 4995, 'Wallace Maxters'), ('StackOverflow.br', 74, 'bfavaretto'), ('StackOverflow.es', 95, 'Jorgesys'), ('StackOverflow.es', 250, 'Alvaro Montoro'), ('StackOverflow.es', 15301, 'Pikoh'), ('StackOverflow.es', 324, 'gbianchi'), ('StackOverflow.ru', 181472, 'Nick Volynkin'), ('StackOverflow.ru', 17609, 'ЮрийСПб'), ('StackOverflow.ru', 178988, 'Qwertiy'), ('StackOverflow.ru', 5648, 'Barmaley'), ('StackOverflow.ru', 186999, 'Grundy'), ('StackOverflow.ru', 1984, 'Nofate'), ('StackExchange.stellar', 683, 'Chenmunka'), ('StackExchange.stellar', 169, 'manjuu5'), ('StackExchange.stellar', 111, 'Synesso'), ('superuser', 307, 'random'), ('superuser', 4377, 'Sathyajith Bhat'), ('superuser', 6574, 'studiohack'), ('superuser', 22317, 'Daniel Beck'), ('superuser', 10165, 'Journeyman Geek'), ('superuser', 19943, 'Mokubai'), ('superuser', 337631, 'DavidPostill'), ('StackExchange.sustainability', 3379, 'LShaver'), ('StackExchange.sustainability', 1056, 'Nic'), ('StackExchange.sustainability', 99, 'THelper'), ('StackExchange.tex', 2975, 'Martin Scharrer'), ('StackExchange.tex', 73, 'Joseph Wright'), ('StackExchange.tex', 213, 'Stefan Kottwitz'), ('StackExchange.tezos', 118, 'Ezy'), ('StackExchange.tezos', 121, 'cousinit'), ('StackExchange.outdoors', 2303, 'WedaPashi'), ('StackExchange.outdoors', 15142, 'Willeke'), ('StackExchange.outdoors', 66, 'Rory Alsop'), ('StackExchange.workplace', 25739, 'Lilienthal'), ('StackExchange.workplace', 73791, 'DarkCygnus'), ('StackExchange.workplace', 40669, 'Kilisi'), ('StackExchange.workplace', 64903, 'motosubatsu'), ('StackExchange.cstheory', 123, 'Lev Reyzin'), ('StackExchange.cstheory', 1037, 'Artem Kaznatcheev'), ('StackExchange.cstheory', 1993, 'Bjørn Kjos-Hanssen'), ('StackExchange.tor', 9291, 'Alexey Vesnin'), ('StackExchange.tor', 88, 'Jens Kubieziel'), ('StackExchange.tor', 31632, 'Swangie'), ('StackExchange.travel', 9009, 'JonathanReez'), ('StackExchange.travel', 22140, 'JoErNanO'), ('StackExchange.travel', 27650, 'Willeke'), ('StackExchange.travel', 108, 'Ankur Banerjee'), ('StackExchange.tridion', 129, 'Dominic Cronin'), ('StackExchange.tridion', 46, 'Alvin Reyes'), ('StackExchange.tridion', 33, 'Nuno Linhares'), ('StackExchange.ukrainian', 69, 'Artemix'), ('StackExchange.ukrainian', 240, 'P. Vowk'), ('StackExchange.ukrainian', 4, 'Sasha'), ('StackExchange.unix', 22222, 'terdon'), ('StackExchange.unix', 7453, 'slm'), ('StackExchange.unix', 116858, 'Kusalananda'), ('StackExchange.unix', 117549, 'Jeff Schaller'), ('StackExchange.ux', 3865, 'JonW'), ('StackExchange.ux', 4595, 'JohnGB'), ('StackExchange.ux', 27659, 'Michael Lai'), ('StackExchange.vegetarian', 70, 'Erica'), ('StackExchange.vegetarian', 77, 'Niitaku'), ('StackExchange.vi', 10604, 'D. Ben Knoble'), ('StackExchange.vi', 25, 'Dom'), ('StackExchange.vi', 18609, 'filbranden'), ('StackExchange.audio', 2836, 'AJ Henderson'), ('StackExchange.audio', 674, 'Dr Mayhem'), ('StackExchange.audio', 3295, 'timonsku'), ('StackExchange.webapps', 310, 'Sathyajith Bhat'), ('StackExchange.webapps', 88163, 'Rubén'), ('StackExchange.webapps', 21, 'ChrisF'), ('StackExchange.webmasters', 14543, 'Stephen Ostermiller'), ('StackExchange.webmasters', 28389, 'dan'), ('StackExchange.webmasters', 1253, 'John Conde'), ('StackExchange.windowsphone', 1401, 'Indrek'), ('StackExchange.windowsphone', 106, 'Rowland Shaw'), ('StackExchange.woodworking', 1821, 'Ashlar'), ('StackExchange.woodworking', 27, 'bowlturner'), ('StackExchange.woodworking', 49, 'rob'), ('StackExchange.wordpress', 73, 'fuxia'), ('StackExchange.wordpress', 736, 'Tom J Nowell'), ('StackExchange.wordpress', 7355, 'Howdy_McGee'), ('StackExchange.wordpress', 94498, 'Jack Johansson'), ('StackExchange.wordpress', 34172, 'Krzysiek Dróżdż'), ('StackExchange.wordpress', 24875, 'Christine Cooper'), ('StackExchange.worldbuilding', 627, 'HDE 226868'), ('StackExchange.worldbuilding', 75, 'Monty Wild'), ('StackExchange.worldbuilding', 30492, 'L.Dutch'), ('StackExchange.writers', 23927, 'F1Krazy'), ('StackExchange.writers', 33442, 'linksassin'), ('StackExchange.writers', 24645, 'motosubatsu'), ('StackExchange.rus', 178412, 'Aer'), ('StackExchange.rus', 1067, 'Марк Из'), ('StackOverflow.ja', 3060, 'cubick'), ('StackOverflow.ja', 19110, 'nekketsuuu'), ('StackOverflow.ja', 754, 'Yuki Inoue');
-- Moderators across all sites, current as of 7/29/21 --
-- Pulled using Glorfindel's script: https://meta.stackexchange.com/questions/115620/please-provide-a-moderators-table-in-the-data-explorer/316250#316250
-- Site DB names cross-referenced using: https://meta.stackexchange.com/questions/359794/how-can-i-get-urls-and-site-names-for-a-cross-site-sede-query/359796#359796

-- Pull network account IDs of all moderators
CREATE TABLE #results (AccountId int);
declare @sql nvarchar(max) = ''
SELECT @sql = @sql
+ IIF( LEN(@sql) > 1 
     , 'UNION'
     , 'INSERT INTO #results'
) +
N'
  SELECT TOP 1 u.AccountId
  FROM ' + QUOTENAME(site) + '.dbo.Users u
  WHERE u.Id = ' + CONCAT('''', userid, '''')
FROM #mods
EXEC (@sql);

-- Pull stats for current site, first for mods, then all users
SELECT 
  'Moderators' AS [Category],
  COUNT(*) AS [Total Active in Last 6 Mths]
FROM #results r
JOIN Users u ON u.AccountId = r.AccountId
WHERE u.LastAccessDate > DATEADD(month, -6, GETDATE())
UNION ALL
SELECT 
  'All Users on Site' AS [Category],
  COUNT(*) AS [Total Active in Last 6 Mths]
FROM Users u 
WHERE u.LastAccessDate > DATEADD(month, -6, GETDATE())
ORDER BY COUNT(*)

Enter Parameters

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