Questions closed by multiple moderators (networkwide)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- from https://meta.stackexchange.com/a/316250/295232
CREATE TABLE #mods (site nvarchar(50), userid int, username nvarchar(50));
INSERT INTO #mods VALUES ('3dprinting.stackexchange.com', 5740, '0scar'), ('3dprinting.stackexchange.com', 4762, 'Greenonline'), ('3dprinting.stackexchange.com', 2146, 'StarWind0'), ('academia.stackexchange.com', 53, 'aeismail'), ('academia.stackexchange.com', 73, 'eykanal'), ('academia.stackexchange.com', 11365, 'ff524'), ('academia.stackexchange.com', 929, 'StrongBad'), ('academia.stackexchange.com', 7734, 'Wrzlprmft'), ('ham.stackexchange.com', 76, 'Kevin Reid AG6YO'), ('ham.stackexchange.com', 8717, 'Mike Waters'), ('ham.stackexchange.com', 873, 'Scott Earle'), ('android.stackexchange.com', 10, 'Bryan Denny'), ('android.stackexchange.com', 16575, 'Izzy'), ('android.stackexchange.com', 96277, 'Firelord'), ('android.stackexchange.com', 44325, 'Andrew T.'), ('anime.stackexchange.com', 63, 'кяαzєя'), ('anime.stackexchange.com', 1908, 'senshin'), ('anime.stackexchange.com', 1458, 'Dimitri mx'), ('arduino.stackexchange.com', 10794, 'Nick Gammon'), ('arduino.stackexchange.com', 4143, 'Majenko'), ('arduino.stackexchange.com', 37523, 'VE7JRO'), ('gaming.stackexchange.com', 8350, 'Wipqozn'), ('gaming.stackexchange.com', 28182, 'Robotnik'), ('gaming.stackexchange.com', 20456, 'Frank'), ('gaming.stackexchange.com', 143571, 'Wrigglenite'), ('ai.stackexchange.com', 75, 'Ben N'), ('ai.stackexchange.com', 1671, 'DukeZhou'), ('ai.stackexchange.com', 4398, 'Jaden Travnik'), ('crafts.stackexchange.com', 30, 'Erica'), ('crafts.stackexchange.com', 24, 'Web Head'), ('apple.stackexchange.com', 5472, 'bmike'), ('apple.stackexchange.com', 9388, 'Daniel'), ('apple.stackexchange.com', 292, 'Ian C.'), ('apple.stackexchange.com', 9058, 'nohillside'), ('apple.stackexchange.com', 37797, 'grg'), ('apple.stackexchange.com', 168832, 'Monomeeth'), ('apple.stackexchange.com', 121968, 'Glorfindel'), ('askubuntu.com', 449, 'Oli'), ('askubuntu.com', 1067, 'Stefano Palazzo'), ('askubuntu.com', 41, 'Marco Ceppi'), ('askubuntu.com', 14356, 'fossfreedom'), ('askubuntu.com', 6005, 'jrg'), ('askubuntu.com', 1992, 'RolandiXor'), ('askubuntu.com', 25798, 'jokerdino'), ('askubuntu.com', 44179, 'Seth'), ('askubuntu.com', 59676, 'Mitch'), ('askubuntu.com', 85695, 'terdon'), ('askubuntu.com', 10616, 'Thomas Ward'), ('askubuntu.com', 367990, 'Byte Commander'), ('astronomy.stackexchange.com', 6, 'called2voyage'), ('astronomy.stackexchange.com', 38, 'Donald.McLean'), ('astronomy.stackexchange.com', 2153, 'HDE 226868'), ('aviation.stackexchange.com', 65, 'Farhan'), ('aviation.stackexchange.com', 1467, 'Federico'), ('aviation.stackexchange.com', 100, 'Jamiec'), ('aviation.stackexchange.com', 1696, 'fooot'), ('alcohol.stackexchange.com', 5078, 'Jamie Eltringham'), ('alcohol.stackexchange.com', 43, 'Monica Cellio'), ('alcohol.stackexchange.com', 37, 'Xander'), ('hermeneutics.stackexchange.com', 36, 'Caleb'), ('hermeneutics.stackexchange.com', 33, 'Soldarnal'), ('hermeneutics.stackexchange.com', 3555, 'Susan'), ('bicycles.stackexchange.com', 213, 'Gary.Ray'), ('bicycles.stackexchange.com', 76, 'freiheit'), ('bicycles.stackexchange.com', 4239, 'jimchristie'), ('bicycles.stackexchange.com', 19705, 'Criggie'), ('bioinformatics.stackexchange.com', 77, 'Devon Ryan'), ('bioinformatics.stackexchange.com', 298, 'terdon'), ('bioinformatics.stackexchange.com', 37, 'user172818'), ('biology.stackexchange.com', 5144, 'Chris'), ('biology.stackexchange.com', 9943, 'AliceD'), ('biology.stackexchange.com', 16866, 'theforestecologist'), ('biology.stackexchange.com', 27148, 'Bryan Krause'), ('bitcoin.stackexchange.com', 5406, 'Murch'), ('bitcoin.stackexchange.com', 48884, 'Andrew Chow'), ('bitcoin.stackexchange.com', 51948, 'MeshCollider'), ('blender.stackexchange.com', 12, 'iKlsR'), ('blender.stackexchange.com', 599, 'gandalf3'), ('blender.stackexchange.com', 2217, 'David'), ('blender.stackexchange.com', 19307, 'Duarte Farrajota Ramos'), ('boardgames.stackexchange.com', 409, 'Cascabel'), ('boardgames.stackexchange.com', 2537, 'murgatroid99'), ('boardgames.stackexchange.com', 40, 'Pat Ludwig'), ('bricks.stackexchange.com', 132, 'Ambo100'), ('bricks.stackexchange.com', 708, 'jncraton'), ('bricks.stackexchange.com', 56, 'Zhaph - Ben Duguid'), ('buddhism.stackexchange.com', 43, 'Andrei Volkov'), ('buddhism.stackexchange.com', 254, 'ChrisW'), ('buddhism.stackexchange.com', 2424, 'Lanka'), ('chemistry.stackexchange.com', 4945, 'Martin - マーチン'), ('chemistry.stackexchange.com', 73, 'jonsca'), ('chemistry.stackexchange.com', 7951, 'Loong'), ('chemistry.stackexchange.com', 16683, 'orthocresol'), ('chemistry.stackexchange.com', 41328, 'andselisk'), ('chemistry.stackexchange.com', 402, 'Melanie Shebel'), ('chess.stackexchange.com', 12, 'Andrew'), ('chess.stackexchange.com', 4418, 'Brian Towers'), ('chess.stackexchange.com', 86, 'Daniel'), ('chess.stackexchange.com', 7297, 'Glorfindel'), ('chinese.stackexchange.com', 43, 'Alenanno'), ('chinese.stackexchange.com', 16, 'Don Kirkby'), ('chinese.stackexchange.com', 4072, 'songyuanyao'), ('chinese.stackexchange.com', 4136, 'user3306356'), ('christianity.stackexchange.com', 68, 'Mason Wheeler'), ('christianity.stackexchange.com', 30, 'Caleb'), ('christianity.stackexchange.com', 58, 'El''endia Starman'), ('christianity.stackexchange.com', 4, 'Peter Turner'), ('christianity.stackexchange.com', 21576, 'Nathaniel'), ('civicrm.stackexchange.com', 225, 'Aidan'), ('civicrm.stackexchange.com', 40, 'Joe Murray'), ('civicrm.stackexchange.com', 96, 'petednz - fuzion'), ('codegolf.stackexchange.com', 12012, 'Dennis'), ('codegolf.stackexchange.com', 3808, 'Doorknob'), ('codegolf.stackexchange.com', 45941, 'Mego'), ('codegolf.stackexchange.com', 31716, 'DJMcMayhem'), ('codereview.stackexchange.com', 22222, 'Jamal'), ('codereview.stackexchange.com', 37660, 'Vogel612'), ('codereview.stackexchange.com', 31503, 'rolfl'), ('codereview.stackexchange.com', 18427, 'Malachi'), ('coffee.stackexchange.com', 127, 'fredley'), ('coffee.stackexchange.com', 262, 'hoc_age'), ('coffee.stackexchange.com', 25, 'Nick Udell'), ('communitybuilding.stackexchange.com', 105, 'ChrisF'), ('communitybuilding.stackexchange.com', 11, 'AJ Henderson'), ('communitybuilding.stackexchange.com', 78, 'Andy'), ('scicomp.stackexchange.com', 20688, 'Anton Menshov'), ('scicomp.stackexchange.com', 9667, 'nicoguaro'), ('scicomp.stackexchange.com', 549, 'Paul'), ('computergraphics.stackexchange.com', 2041, 'Dan Hulme'), ('computergraphics.stackexchange.com', 231, 'trichoplax'), ('cs.stackexchange.com', 98, 'Raphael'), ('cs.stackexchange.com', 755, 'D.W.'), ('cs.stackexchange.com', 39, 'Gilles'), ('cs.stackexchange.com', 65339, 'Discrete lizard'), ('cseducators.stackexchange.com', 27, 'Ben I.'), ('cseducators.stackexchange.com', 76, 'Peter'), ('cseducators.stackexchange.com', 58, 'thesecretmaster'), ('conlang.stackexchange.com', 142, 'jknappen'), ('conlang.stackexchange.com', 113, 'curiousdannii'), ('conlang.stackexchange.com', 52, 'Sparksbet'), ('craftcms.stackexchange.com', 103, 'Anna_MediaGirl'), ('craftcms.stackexchange.com', 45, 'Lindsey D'), ('craftcms.stackexchange.com', 22, 'Matt Stein'), ('stats.stackexchange.com', 919, 'whuber'), ('stats.stackexchange.com', 686, 'Peter Flom'), ('stats.stackexchange.com', 805, 'Glen_b'), ('stats.stackexchange.com', 17230, 'Scortchi'), ('stats.stackexchange.com', 7290, 'gung'), ('stats.stackexchange.com', 35989, 'Tim'), ('crypto.stackexchange.com', 23623, 'SEJPM'), ('crypto.stackexchange.com', 1172, 'Maarten Bodewes'), ('crypto.stackexchange.com', 29554, 'Ella Rose'), ('datascience.stackexchange.com', 11097, 'Dawny33'), ('datascience.stackexchange.com', 29575, 'Stephen Rauch'), ('datascience.stackexchange.com', 23305, 'oW_'), ('dba.stackexchange.com', 1396, 'Jack Douglas'), ('dba.stackexchange.com', 171, 'jcolebrand'), ('dba.stackexchange.com', 1186, 'Aaron Bertrand'), ('dba.stackexchange.com', 1192, 'Paul White'), ('devops.stackexchange.com', 72, 'Dave Swersky'), ('devops.stackexchange.com', 46, 'Dawny33'), ('devops.stackexchange.com', 13, 'Tensibai'), ('drupal.stackexchange.com', 190, 'googletorp'), ('drupal.stackexchange.com', 199, 'kiamlaluno'), ('drupal.stackexchange.com', 835, 'mpdonadio'), ('drupal.stackexchange.com', 2800, 'Clive'), ('earthscience.stackexchange.com', 64, 'casey'), ('earthscience.stackexchange.com', 6, 'gerrit'), ('earthscience.stackexchange.com', 20, 'hichris123'), ('ebooks.stackexchange.com', 38, 'Ed Cottrell'), ('ebooks.stackexchange.com', 142, 'Jason Down'), ('ebooks.stackexchange.com', 45, 'Nathan Osman'), ('economics.stackexchange.com', 8815, 'EconJohn'), ('economics.stackexchange.com', 4251, 'Kitsune Cavalry'), ('economics.stackexchange.com', 108, 'Ubiquitous'), ('electronics.stackexchange.com', 638, 'W5VO'), ('electronics.stackexchange.com', 7348, 'clabacchio'), ('electronics.stackexchange.com', 11683, 'Dave Tweed'), ('electronics.stackexchange.com', 7036, 'Nick Alexeev'), ('elementaryos.stackexchange.com', 16827, 'Hasan'), ('elementaryos.stackexchange.com', 3018, 'Maccer'), ('elementaryos.stackexchange.com', 26, 'Lewis Goddard'), ('emacs.stackexchange.com', 253, 'Dan'), ('emacs.stackexchange.com', 25, 'Gilles'), ('emacs.stackexchange.com', 12563, 'DoMiNeLa10'), ('engineering.stackexchange.com', 16, 'GlenH7'), ('engineering.stackexchange.com', 33, 'hazzey'), ('engineering.stackexchange.com', 1832, 'Wasabi'), ('english.stackexchange.com', 300, 'RegDwigнt'), ('english.stackexchange.com', 39, 'nohat'), ('english.stackexchange.com', 8360, 'Kit Z. Fox'), ('english.stackexchange.com', 18696, 'Andrew Leach'), ('english.stackexchange.com', 3119, 'Yoichi Oishi'), ('english.stackexchange.com', 3559, 'Matt E. Эллен'), ('english.stackexchange.com', 2085, 'tchrist'), ('ell.stackexchange.com', 113, 'J.R.'), ('ell.stackexchange.com', 3187, 'Maulik V'), ('ell.stackexchange.com', 9161, 'ColleenV'), ('ell.stackexchange.com', 230, 'snailboat'), ('ell.stackexchange.com', 36187, 'Em.'), ('eosio.stackexchange.com', 851, 'John Williamson'), ('eosio.stackexchange.com', 1232, 'Phillip Hamnett - EOS42'), ('eosio.stackexchange.com', 15, 'TeeAttack42'), ('esperanto.stackexchange.com', 1576, 'das-g'), ('esperanto.stackexchange.com', 13, 'Neil Roberts'), ('esperanto.stackexchange.com', 369, 'svendvn'), ('ethereum.stackexchange.com', 42, 'eth'), ('ethereum.stackexchange.com', 2021, 'Badr Bellaj'), ('ethereum.stackexchange.com', 131, 'Tjaden Hess'), ('expatriates.stackexchange.com', 97, 'Mark Mayo'), ('expatriates.stackexchange.com', 127, 'StrongBad'), ('expatriates.stackexchange.com', 25, 'SztupY'), ('expressionengine.stackexchange.com', 28, 'Anna_MediaGirl'), ('expressionengine.stackexchange.com', 22, 'Alex Kendrick'), ('expressionengine.stackexchange.com', 55, 'Derek Hogue'), ('freelancing.stackexchange.com', 15202, 'JohnHC'), ('freelancing.stackexchange.com', 75, 'Canadian Luke'), ('french.stackexchange.com', 82, 'Evpok'), ('french.stackexchange.com', 5, 'Gilles'), ('french.stackexchange.com', 79, 'Stéphane Gimenez'), ('gamedev.stackexchange.com', 14, 'Jesse Dorsey'), ('gamedev.stackexchange.com', 1430, 'Josh'), ('gamedev.stackexchange.com', 7191, 'MichaelHouse'), ('gamedev.stackexchange.com', 40264, 'Alexandre Vaillancourt'), ('gamedev.stackexchange.com', 39518, 'DMGregory'), ('gardening.stackexchange.com', 499, 'kevinsky'), ('gardening.stackexchange.com', 26, 'Niall C.'), ('gardening.stackexchange.com', 7456, 'Stephie'), ('genealogy.stackexchange.com', 1107, 'Harry Vervet'), ('genealogy.stackexchange.com', 1006, 'Jan Murphy'), ('genealogy.stackexchange.com', 19, 'PolyGeo'), ('gis.stackexchange.com', 664, 'whuber'), ('gis.stackexchange.com', 276, 'Mapperz'), ('gis.stackexchange.com', 187, 'underdark'), ('gis.stackexchange.com', 79, 'Ian Turton'), ('gis.stackexchange.com', 115, 'PolyGeo'), ('gis.stackexchange.com', 8104, 'Aaron'), ('gis.stackexchange.com', 7424, 'Fezter'), ('gis.stackexchange.com', 64785, 'Midavalo'), ('german.stackexchange.com', 9551, 'Loong'), ('german.stackexchange.com', 23, 'Takkat'), ('german.stackexchange.com', 2594, 'Wrzlprmft'), ('graphicdesign.stackexchange.com', 9447, 'DᴀʀᴛʜVᴀᴅᴇʀ'), ('graphicdesign.stackexchange.com', 2611, 'Ryan'), ('graphicdesign.stackexchange.com', 19174, 'Wrzlprmft'), ('graphicdesign.stackexchange.com', 18168, 'Emilie'), ('graphicdesign.stackexchange.com', 41100, 'PieBie'), ('hardwarerecs.stackexchange.com', 57, 'Andy'), ('hardwarerecs.stackexchange.com', 8, 'ArtOfCode'), ('hardwarerecs.stackexchange.com', 60, 'Cfinley'), ('hinduism.stackexchange.com', 36, 'Keshav Srinivasan'), ('hinduism.stackexchange.com', 277, 'Paṇḍyā'), ('hinduism.stackexchange.com', 3500, 'The Destroyer'), ('history.stackexchange.com', 1401, 'Mark C. Wallace'), ('history.stackexchange.com', 4935, 'Semaphore'), ('history.stackexchange.com', 24858, 'sempaiscuba'), ('history.stackexchange.com', 771, 'T.E.D.'), ('hsm.stackexchange.com', 26, 'Danu'), ('hsm.stackexchange.com', 62, 'HDE 226868'), ('hsm.stackexchange.com', 58, 'Logan M'), ('diy.stackexchange.com', 194, 'ChrisF'), ('diy.stackexchange.com', 2196, 'BMitch'), ('diy.stackexchange.com', 22, 'Niall C.'), ('diy.stackexchange.com', 7367, 'Michael Karas'), ('homebrew.stackexchange.com', 14765, 'farmersteve'), ('homebrew.stackexchange.com', 12182, 'Mr_road'), ('homebrew.stackexchange.com', 12609, 'thesquaregroot'), ('security.stackexchange.com', 33, 'AviD'), ('security.stackexchange.com', 485, 'Rory Alsop'), ('security.stackexchange.com', 836, 'Jeff Ferland'), ('security.stackexchange.com', 6253, 'schroeder'), ('iot.stackexchange.com', 49, 'anonymous2'), ('iot.stackexchange.com', 12, 'Aurora0001'), ('iot.stackexchange.com', 78, 'Helmar'), ('interpersonal.stackexchange.com', 4550, 'avazula'), ('interpersonal.stackexchange.com', 29, 'A J'), ('interpersonal.stackexchange.com', 3171, 'Em C'), ('interpersonal.stackexchange.com', 33, 'John'), ('interpersonal.stackexchange.com', 1599, 'Tinkeringbell'), ('iota.stackexchange.com', 19, 'aboose'), ('iota.stackexchange.com', 334, 'Helmar'), ('iota.stackexchange.com', 134, 'mihi'), ('islam.stackexchange.com', 3487, 'Bleeding Fingers'), ('islam.stackexchange.com', 22, 'goldPseudo'), ('islam.stackexchange.com', 13438, 'Medi1Saif'), ('italian.stackexchange.com', 707, 'Charo'), ('italian.stackexchange.com', 1818, 'Denis Nardin'), ('italian.stackexchange.com', 70, 'egreg'), ('japanese.stackexchange.com', 1478, 'snailboat'), ('japanese.stackexchange.com', 1628, 'Earthliŋ'), ('japanese.stackexchange.com', 542, 'Flaw'), ('japanese.stackexchange.com', 9831, 'Chocolate'), ('joomla.stackexchange.com', 126, 'FFrewin'), ('joomla.stackexchange.com', 12352, 'mickmackusa'), ('korean.stackexchange.com', 64, 'topo morto'), ('korean.stackexchange.com', 91, 'user17915'), ('korean.stackexchange.com', 26, 'Vladhagen'), ('languagelearning.stackexchange.com', 800, 'Christophe Strobbe'), ('languagelearning.stackexchange.com', 85, 'Hatchet'), ('languagelearning.stackexchange.com', 46, 'Tom Au'), ('latin.stackexchange.com', 30, 'Cerberus'), ('latin.stackexchange.com', 79, 'Joonas Ilmavirta'), ('latin.stackexchange.com', 12, 'Nathaniel'), ('law.stackexchange.com', 10, 'feetwet'), ('law.stackexchange.com', 65, 'cnst'), ('law.stackexchange.com', 480, 'Pat W.'), ('law.stackexchange.com', 344, 'Dale M'), ('lifehacks.stackexchange.com', 6973, 'Chenmunka'), ('lifehacks.stackexchange.com', 4198, 'BrettFromLA'), ('lifehacks.stackexchange.com', 20, 'michaelpri'), ('lifehacks.stackexchange.com', 15, 'Mooseman'), ('linguistics.stackexchange.com', 111, 'Alenanno'), ('linguistics.stackexchange.com', 13238, 'lemontree'), ('linguistics.stackexchange.com', 126, 'prash'), ('literature.stackexchange.com', 80, 'Aza'), ('literature.stackexchange.com', 11, 'Gallifreyan'), ('literature.stackexchange.com', 58, 'Mithrandir'), ('magento.stackexchange.com', 146, 'Marius'), ('magento.stackexchange.com', 50, 'Sander Mangel'), ('magento.stackexchange.com', 4564, 'Amit Bera'), ('martialarts.stackexchange.com', 548, 'JohnP'), ('martialarts.stackexchange.com', 5961, 'mattm'), ('martialarts.stackexchange.com', 70, 'slugster'), ('mathematica.stackexchange.com', 121, 'Mr.Wizard'), ('mathematica.stackexchange.com', 5, 'rm -rf'), ('mathematica.stackexchange.com', 50, 'J. M. will be back soon'), ('mathematica.stackexchange.com', 5478, 'Kuba'), ('mathematica.stackexchange.com', 187, 'halirutan'), ('math.stackexchange.com', 9754, 'davidlowryduda'), ('math.stackexchange.com', 13854, 'robjohn'), ('math.stackexchange.com', 21674, 'Michael Greinecker'), ('math.stackexchange.com', 12952, 'Alexander Gruber'), ('math.stackexchange.com', 23350, 'Pedro Tamaroff'), ('math.stackexchange.com', 85306, 'quid'), ('math.stackexchange.com', 622, 'Asaf Karagila'), ('math.stackexchange.com', 59234, 'Aloizio Macedo'), ('matheducators.stackexchange.com', 11, 'Chris Cunningham'), ('matheducators.stackexchange.com', 143, 'quid'), ('matheducators.stackexchange.com', 60, 'Sue VanHattum'), ('mathoverflow.net', 2926, 'Todd Trimble'), ('mathoverflow.net', 66, 'Ben Webster'), ('mathoverflow.net', 2, 'David Zureick-Brown'), ('mathoverflow.net', 2000, 'François G. Dorais'), ('mathoverflow.net', 121, 'S. Carnahan'), ('mathoverflow.net', 3, 'Scott Morrison'), ('medicalsciences.stackexchange.com', 805, 'Carey Gregory'), ('medicalsciences.stackexchange.com', 64, 'JohnP'), ('medicalsciences.stackexchange.com', 26, 'michaelpri'), ('meta.stackexchange.com', 59303, 'ChrisF'), ('meta.stackexchange.com', 135565, 'Journeyman Geek'), ('meta.stackexchange.com', 162102, 'Monica Cellio'), ('meta.stackexchange.com', 369802, 'Tinkeringbell'), ('judaism.stackexchange.com', 472, 'Monica Cellio'), ('judaism.stackexchange.com', 759, 'Double AA'), ('judaism.stackexchange.com', 170, 'msh210'), ('judaism.stackexchange.com', 2, 'Isaac Moses'), ('monero.stackexchange.com', 7493, 'jtgrassie'), ('monero.stackexchange.com', 44, 'dEBRUYNE'), ('monero.stackexchange.com', 42, 'sgp'), ('mechanics.stackexchange.com', 4152, 'Pᴀᴜʟsᴛᴇʀ2'), ('mechanics.stackexchange.com', 57, 'Bob Cross'), ('mechanics.stackexchange.com', 373, 'Nick C'), ('movies.stackexchange.com', 40, 'iandotkelly'), ('movies.stackexchange.com', 49, 'Napoleon Wilson'), ('movies.stackexchange.com', 27264, 'A J'), ('musicfans.stackexchange.com', 7, 'Dom'), ('musicfans.stackexchange.com', 27, 'Donald.McLean'), ('musicfans.stackexchange.com', 53, 'Johnny Bones'), ('music.stackexchange.com', 28, 'Matthew Read'), ('music.stackexchange.com', 7222, 'Dom'), ('music.stackexchange.com', 104, 'Doktor Mayhem'), ('mythology.stackexchange.com', 183, 'HDE 226868'), ('mythology.stackexchange.com', 108, 'Semaphore'), ('mythology.stackexchange.com', 57, 'yannis'), ('networkengineering.stackexchange.com', 33, 'YLearn'), ('networkengineering.stackexchange.com', 509, 'Teun Vink'), ('networkengineering.stackexchange.com', 8499, 'Ron Maupin'), ('opendata.stackexchange.com', 90, 'albert'), ('opendata.stackexchange.com', 70, 'Patrick Hoefler'), ('opendata.stackexchange.com', 1511, 'philshem'), ('opensource.stackexchange.com', 50, 'apsillers'), ('opensource.stackexchange.com', 98, 'ArtOfCode'), ('opensource.stackexchange.com', 69, 'Zizouz212'), ('or.stackexchange.com', 36, 'EhsanK'), ('or.stackexchange.com', 38, 'LarrySnyder610'), ('or.stackexchange.com', 123, 'TheSimpliFire'), ('parenting.stackexchange.com', 9327, 'anongoodnurse'), ('parenting.stackexchange.com', 6524, 'Joe'), ('parenting.stackexchange.com', 316, 'Rory Alsop'), ('money.stackexchange.com', 187, 'JoeTaxpayer'), ('money.stackexchange.com', 149, 'JohnFx'), ('money.stackexchange.com', 366, 'Ganesh Sittampalam'), ('pets.stackexchange.com', 5456, 'Harry V.'), ('pets.stackexchange.com', 6826, 'Henders'), ('pets.stackexchange.com', 13, 'James Jenkins'), ('pets.stackexchange.com', 7526, 'Rebecca RVT'), ('philosophy.stackexchange.com', 81, 'Joseph Weissman'), ('philosophy.stackexchange.com', 2953, 'Keelan'), ('philosophy.stackexchange.com', 17209, 'Philip Klöcking'), ('philosophy.stackexchange.com', 29361, 'Geoffrey Thomas'), ('photo.stackexchange.com', 124, 'jrista'), ('photo.stackexchange.com', 4191, 'MikeW'), ('photo.stackexchange.com', 11392, 'AJ Henderson'), ('fitness.stackexchange.com', 8828, 'Alec'), ('fitness.stackexchange.com', 7091, 'Eric'), ('fitness.stackexchange.com', 3736, 'JohnP'), ('physics.stackexchange.com', 124, 'David Z'), ('physics.stackexchange.com', 520, 'dmckee'), ('physics.stackexchange.com', 2451, 'Qmechanic'), ('physics.stackexchange.com', 44126, 'rob'), ('physics.stackexchange.com', 50583, 'ACuriousMind'), ('physics.stackexchange.com', 6634, 'tpg2114'), ('physics.stackexchange.com', 106502, 'Chris'), ('poker.stackexchange.com', 3538, 'Grinch91'), ('poker.stackexchange.com', 309, 'Radu Murzea'), ('poker.stackexchange.com', 88, 'Toby Booth'), ('politics.stackexchange.com', 3135, 'Philipp'), ('politics.stackexchange.com', 193, 'Sam I am'), ('politics.stackexchange.com', 101, 'yannis'), ('portuguese.stackexchange.com', 157, 'ANeves'), ('portuguese.stackexchange.com', 153, 'Jorge B.'), ('portuguese.stackexchange.com', 38, 'tchrist'), ('pm.stackexchange.com', 14, 'Mark Phillips'), ('pm.stackexchange.com', 430, 'Tiago Cardoso'), ('pm.stackexchange.com', 4271, 'Todd A. Jacobs'), ('psychology.stackexchange.com', 6983, 'AliceD'), ('psychology.stackexchange.com', 7001, 'Arnon Weinberg'), ('psychology.stackexchange.com', 52, 'Jeromy Anglim'), ('psychology.stackexchange.com', 21, 'Steven Jeuris'), ('puzzling.stackexchange.com', 11876, 'Deusovi'), ('puzzling.stackexchange.com', 4421, 'GentlePurpleRain'), ('puzzling.stackexchange.com', 19114, 'Gareth McCaughan'), ('puzzling.stackexchange.com', 30633, 'Rubio'), ('quant.stackexchange.com', 848, 'Bob Jansen'), ('quant.stackexchange.com', 70, 'olaker'), ('quant.stackexchange.com', 29443, 'Attack68'), ('quantumcomputing.stackexchange.com', 91, 'heather'), ('quantumcomputing.stackexchange.com', 23, 'Mithrandir24601'), ('raspberrypi.stackexchange.com', 5538, 'goldilocks'), ('raspberrypi.stackexchange.com', 19949, 'Ghanima'), ('raspberrypi.stackexchange.com', 8496, 'Jacobm001'), ('raspberrypi.stackexchange.com', 24296, 'Darth Vader'), ('retrocomputing.stackexchange.com', 276, 'Chenmunka'), ('retrocomputing.stackexchange.com', 107, 'Matt Lacey'), ('retrocomputing.stackexchange.com', 278, 'wizzwizz4'), ('reverseengineering.stackexchange.com', 245, '0xC0000022L'), ('reverseengineering.stackexchange.com', 60, 'Igor Skochinsky'), ('reverseengineering.stackexchange.com', 18317, 'julian'), ('robotics.stackexchange.com', 134, 'Andrew'), ('robotics.stackexchange.com', 110, 'Ben'), ('robotics.stackexchange.com', 9720, 'Chuck'), ('robotics.stackexchange.com', 37, 'Mark Booth'), ('rpg.stackexchange.com', 23970, 'nitsua60'), ('rpg.stackexchange.com', 1204, 'doppelgreener'), ('rpg.stackexchange.com', 28591, 'Rubiksmoose'), ('rpg.stackexchange.com', 33569, 'V2Blast'), ('russian.stackexchange.com', 3680, 'Dmitry'), ('russian.stackexchange.com', 134, 'Quassnoi'), ('russian.stackexchange.com', 242, 'shabunc'), ('salesforce.stackexchange.com', 78, 'Matt Lacey'), ('salesforce.stackexchange.com', 2995, 'Adrian Larson'), ('salesforce.stackexchange.com', 46017, 'David Reed'), ('scifi.stackexchange.com', 3804, 'AncientSwordRage'), ('scifi.stackexchange.com', 3267, 'Kevin'), ('scifi.stackexchange.com', 2765, 'Thaddeus Howze'), ('scifi.stackexchange.com', 31394, 'Rand al''Thor'), ('scifi.stackexchange.com', 31936, 'Null'), ('cooking.stackexchange.com', 4638, 'rumtscho'), ('cooking.stackexchange.com', 1672, 'Cascabel'), ('cooking.stackexchange.com', 28879, 'Stephie'), ('cooking.stackexchange.com', 20183, 'Jolenealaska'), ('serverfault.com', 3038, 'sysadmin1138'), ('serverfault.com', 126632, 'Michael Hampton'), ('serverfault.com', 8897, 'Sven'), ('serverfault.com', 1375, 'womble'), ('serverfault.com', 6177, 'Ward'), ('serverfault.com', 256639, 'yagmoth555'), ('sharepoint.stackexchange.com', 62, 'SPDoctor'), ('sharepoint.stackexchange.com', 6382, 'Benny Skogberg'), ('sharepoint.stackexchange.com', 21563, 'Waqas Sarwar MVP'), ('sharepoint.stackexchange.com', 53462, 'Mohamed El-Qassas MVP'), ('dsp.stackexchange.com', 8202, 'jojek'), ('dsp.stackexchange.com', 35, 'datageist'), ('dsp.stackexchange.com', 80, 'Peter K.'), ('sitecore.stackexchange.com', 104, 'Dmytro Shevchenko'), ('sitecore.stackexchange.com', 135, 'jammykam'), ('sitecore.stackexchange.com', 73, 'Mark Cassidy'), ('sitecore.stackexchange.com', 70, 'Richard Seal'), ('skeptics.stackexchange.com', 5, 'Mad Scientist'), ('skeptics.stackexchange.com', 23, 'Oddthinking'), ('skeptics.stackexchange.com', 5167, 'Jamiec'), ('skeptics.stackexchange.com', 96, 'Sklivvz'), ('softwareengineering.stackexchange.com', 47, 'ChrisF'), ('softwareengineering.stackexchange.com', 4, 'Thomas Owens'), ('softwareengineering.stackexchange.com', 25476, 'maple_shaft'), ('softwareengineering.stackexchange.com', 53019, 'GlenH7'), ('softwareengineering.stackexchange.com', 1204, 'Robert Harvey'), ('sqa.stackexchange.com', 5574, 'alecxe'), ('sqa.stackexchange.com', 65, 'corsiKa'), ('sqa.stackexchange.com', 422, 'Kate Paulk'), ('softwarerecs.stackexchange.com', 140, 'Nicolas Raoul'), ('softwarerecs.stackexchange.com', 185, 'Izzy'), ('softwarerecs.stackexchange.com', 8503, 'RockPaperLizard'), ('sound.stackexchange.com', 7174, 'AJ Henderson'), ('sound.stackexchange.com', 61, 'Jay Jennings'), ('sound.stackexchange.com', 7016, 'Rory Alsop'), ('space.stackexchange.com', 58, 'called2voyage'), ('space.stackexchange.com', 8693, 'Hohmannfan'), ('space.stackexchange.com', 25, 'PearsonArtPhoto'), ('spanish.stackexchange.com', 12637, 'Charlie'), ('spanish.stackexchange.com', 5481, 'Diego'), ('spanish.stackexchange.com', 1674, 'fedorqui'), ('sports.stackexchange.com', 18, 'jamauss'), ('sports.stackexchange.com', 12, 'Michael Myers'), ('sports.stackexchange.com', 6126, 'Philip Kendall'), ('stackapps.com', 7653, 'Brock Adams'), ('stackapps.com', 18, 'Nathan Osman'), ('stackapps.com', 4746, 'Tim Stone'), ('stackoverflow.com', 13531, 'Michael Myers'), ('stackoverflow.com', 102937, 'Robert Harvey'), ('stackoverflow.com', 106224, 'BoltClock'), ('stackoverflow.com', 16587, 'George Stocker'), ('stackoverflow.com', 19679, 'Brad Larson'), ('stackoverflow.com', 59303, 'ChrisF'), ('stackoverflow.com', 168175, 'Flexo'), ('stackoverflow.com', 707111, 'Ry-'), ('stackoverflow.com', 256196, 'Bohemian'), ('stackoverflow.com', 229044, 'meagar'), ('stackoverflow.com', 100297, 'Martijn Pieters'), ('stackoverflow.com', 1252759, 'Jon Clements'), ('stackoverflow.com', 3093387, 'josliber'), ('stackoverflow.com', 871050, 'Madara Uchiha'), ('stackoverflow.com', 1849664, 'Undo'), ('stackoverflow.com', 476, 'deceze'), ('stackoverflow.com', 541136, 'Aaron Hall'), ('stackoverflow.com', 4099593, 'Bhargav Rao'), ('stackoverflow.com', 189134, 'Andy'), ('stackoverflow.com', 366904, 'Cody Gray'), ('stackoverflow.com', 563532, 'Rob'), ('stackoverflow.com', 2057919, 'Ed Cottrell'), ('stackoverflow.com', 3002139, 'Baum mit Augen'), ('stackoverflow.com', 6451573, 'Jean-François Fabre'), ('stackoverflow.com', 584192, 'Samuel Liew'), ('pt.stackoverflow.com', 74, 'bfavaretto'), ('pt.stackoverflow.com', 3117, 'Math'), ('pt.stackoverflow.com', 129, 'Sergio'), ('pt.stackoverflow.com', 101, 'Maniero'), ('pt.stackoverflow.com', 91, 'rray'), ('pt.stackoverflow.com', 70, 'Bacco'), ('es.stackoverflow.com', 15855, 'lois6b'), ('es.stackoverflow.com', 95, 'Jorgesys'), ('es.stackoverflow.com', 250, 'Alvaro Montoro'), ('es.stackoverflow.com', 15301, 'Pikoh'), ('es.stackoverflow.com', 324, 'gbianchi'), ('ru.stackoverflow.com', 177221, 'PashaPash'), ('ru.stackoverflow.com', 181472, 'Nick Volynkin'), ('ru.stackoverflow.com', 1984, 'Nofate'), ('ru.stackoverflow.com', 17609, 'ЮрийСПб'), ('ru.stackoverflow.com', 178988, 'Qwertiy'), ('ru.stackoverflow.com', 15479, 'Suvitruf'), ('ru.stackoverflow.com', 213987, 'A K'), ('stellar.stackexchange.com', 683, 'Chenmunka'), ('stellar.stackexchange.com', 169, 'Saya'), ('stellar.stackexchange.com', 111, 'Synesso'), ('superuser.com', 307, 'random'), ('superuser.com', 4377, 'Sathyajith Bhat'), ('superuser.com', 6574, 'studiohack'), ('superuser.com', 20088, 'nhinkle'), ('superuser.com', 22317, 'Daniel Beck'), ('superuser.com', 10165, 'Journeyman Geek'), ('superuser.com', 19943, 'Mokubai'), ('superuser.com', 337631, 'DavidPostill'), ('sustainability.stackexchange.com', 85, 'Earthliŋ'), ('sustainability.stackexchange.com', 48, 'EnergyNumbers'), ('sustainability.stackexchange.com', 99, 'THelper'), ('tex.stackexchange.com', 73, 'Joseph Wright'), ('tex.stackexchange.com', 213, 'Stefan Kottwitz'), ('tex.stackexchange.com', 2975, 'Martin Scharrer'), ('tezos.stackexchange.com', 118, 'Ezy'), ('tezos.stackexchange.com', 219, 'Stephen Andrews'), ('tezos.stackexchange.com', 121, 'cousinit'), ('outdoors.stackexchange.com', 18, 'Kevin'), ('outdoors.stackexchange.com', 66, 'Rory Alsop'), ('outdoors.stackexchange.com', 5, 'studiohack'), ('workplace.stackexchange.com', 325, 'Monica Cellio'), ('workplace.stackexchange.com', 33698, 'Jane S'), ('workplace.stackexchange.com', 25739, 'Lilienthal'), ('workplace.stackexchange.com', 44108, 'Snow'), ('workplace.stackexchange.com', 61096, 'Mister Positive'), ('cstheory.stackexchange.com', 123, 'Lev Reyzin'), ('cstheory.stackexchange.com', 1037, 'Artem Kaznatcheev'), ('cstheory.stackexchange.com', 1993, 'Bjørn Kjos-Hanssen'), ('tor.stackexchange.com', 9291, 'Alexey Vesnin'), ('tor.stackexchange.com', 71, 'Andrew Lott'), ('tor.stackexchange.com', 88, 'Jens Kubieziel'), ('travel.stackexchange.com', 108, 'Ankur Banerjee'), ('travel.stackexchange.com', 101, 'Mark Mayo'), ('travel.stackexchange.com', 9009, 'JonathanReez'), ('travel.stackexchange.com', 22140, 'JoErNanO'), ('travel.stackexchange.com', 27650, 'Willeke'), ('tridion.stackexchange.com', 129, 'Dominic Cronin'), ('tridion.stackexchange.com', 46, 'Alvin Reyes'), ('tridion.stackexchange.com', 33, 'Nuno Linhares'), ('ukrainian.stackexchange.com', 69, 'Artemix'), ('ukrainian.stackexchange.com', 240, 'P. Vowk'), ('ukrainian.stackexchange.com', 4, 'Sasha'), ('unix.stackexchange.com', 73, 'Michael Mrozek'), ('unix.stackexchange.com', 22222, 'terdon'), ('unix.stackexchange.com', 7453, 'slm'), ('unix.stackexchange.com', 116858, 'Kusalananda'), ('unix.stackexchange.com', 117549, 'Jeff Schaller'), ('ux.stackexchange.com', 3865, 'JonW'), ('ux.stackexchange.com', 4595, 'JohnGB'), ('ux.stackexchange.com', 27659, 'Michael Lai'), ('vegetarianism.stackexchange.com', 70, 'Erica'), ('vegetarianism.stackexchange.com', 77, 'Niitaku'), ('vegetarianism.stackexchange.com', 6, 'Riker'), ('vi.stackexchange.com', 2920, 'DJMcMayhem'), ('vi.stackexchange.com', 51, 'Martin Tournoij'), ('vi.stackexchange.com', 1841, 'statox'), ('video.stackexchange.com', 2836, 'AJ Henderson'), ('video.stackexchange.com', 674, 'Dr Mayhem'), ('video.stackexchange.com', 3295, 'PTS'), ('webapps.stackexchange.com', 40, 'phwd'), ('webapps.stackexchange.com', 21, 'ChrisF'), ('webapps.stackexchange.com', 5095, 'codingbadger'), ('webapps.stackexchange.com', 310, 'Sathyajith Bhat'), ('webapps.stackexchange.com', 11175, 'jonsca'), ('webmasters.stackexchange.com', 1253, 'John Conde'), ('webmasters.stackexchange.com', 14543, 'Stephen Ostermiller'), ('webmasters.stackexchange.com', 20604, 'Simon Hayter'), ('webmasters.stackexchange.com', 28389, 'dan'), ('windowsphone.stackexchange.com', 1401, 'Indrek'), ('windowsphone.stackexchange.com', 106, 'Rowland Shaw'), ('windowsphone.stackexchange.com', 979, 'Thomas'), ('woodworking.stackexchange.com', 1821, 'Ashlar'), ('woodworking.stackexchange.com', 27, 'bowlturner'), ('woodworking.stackexchange.com', 49, 'rob'), ('wordpress.stackexchange.com', 73, 'fuxia'), ('wordpress.stackexchange.com', 736, 'Tom J Nowell'), ('wordpress.stackexchange.com', 35541, 'gmazzap'), ('wordpress.stackexchange.com', 7355, 'Howdy_McGee'), ('wordpress.stackexchange.com', 94498, 'Jack Johansson'), ('wordpress.stackexchange.com', 34172, 'Krzysiek Dróżdż'), ('wordpress.stackexchange.com', 24875, 'Christine Cooper'), ('worldbuilding.stackexchange.com', 627, 'HDE 226868'), ('worldbuilding.stackexchange.com', 28, 'Monica Cellio'), ('worldbuilding.stackexchange.com', 49, 'Tim B'), ('worldbuilding.stackexchange.com', 29, 'a CVn'), ('worldbuilding.stackexchange.com', 189, 'James'), ('worldbuilding.stackexchange.com', 75, 'Monty Wild'), ('worldbuilding.stackexchange.com', 30492, 'L.Dutch'), ('writing.stackexchange.com', 2533, 'a CVn'), ('writing.stackexchange.com', 32946, 'Cyn'), ('writing.stackexchange.com', 1993, 'Monica Cellio'), ('writing.stackexchange.com', 26, 'Neil Fein'), ('rus.stackexchange.com', 178412, 'Aer'), ('rus.stackexchange.com', 1067, 'Марк Из'), ('ja.stackoverflow.com', 3060, 'cubick'), ('ja.stackoverflow.com', 19110, 'nekketsuuu'), ('ja.stackoverflow.com', 754, 'Yuki Inoue');

-- add database name to #mods table
CREATE TABLE #sites (name nvarchar(50), site nvarchar(50));
INSERT INTO #sites
SELECT name,
  LOWER(
    IIF(PATINDEX('%.Mathoverflow%', name) > 0, 'mathoverflow.net',
      IIF(PATINDEX('%.Ubuntu%', name) > 0, 'askubuntu.com',
        IIF(PATINDEX('StackExchange.%', name) > 0,
          CASE SUBSTRING(name, 15, 200)
          WHEN 'Audio' THEN 'video'
          WHEN 'Beer' THEN 'alcohol'
          WHEN 'CogSci' THEN 'psychology'
          WHEN 'Garage' THEN 'mechanics'
          WHEN 'Health' THEN 'medicalsciences'
          WHEN 'Moderators' THEN 'communitybuilding'
          WHEN 'Photography' THEN 'photo'
          WHEN 'Programmers' THEN 'softwareengineering'
          WHEN 'Vegetarian' THEN 'vegetarianism'
          WHEN 'Writers' THEN 'writing'
          ELSE SUBSTRING(name, 15, 200)
          END + '.stackexchange.com',
          IIF(PATINDEX('StackOverflow.%', name) > 0,
            CASE SUBSTRING(name, 15, 200)
            WHEN 'Br' THEN 'pt'
            ELSE SUBSTRING(name, 15, 200)
            END + '.stackoverflow.com', name + '.com'
          )
        )
      )
    )
  ) AS site
  FROM sys.databases
  WHERE database_id > 5
    AND (name NOT LIKE '%.Meta' OR name = 'StackExchange.Meta');
ALTER TABLE #mods ADD [database] NVARCHAR(50);
UPDATE #mods
  SET #mods.[database] = #sites.name
  FROM #sites WHERE #sites.site = #mods.site;

-- result table, don't rename and keep the site column
create table #results (name nvarchar(250)
                       , id int
                       , postid int
--                       , title nvarchar(250)
                       , numberOfMods int);

declare @sql nvarchar(max) = ''   -- holds build up sql string

-- build one biq union sql, for each db
select @sql = @sql 
+ iif( len(@sql) > 1 
     , 'union'
     , 'insert into #results'
) +
-- here goes the per site query, fully qualify the database objects
N'
SELECT ''' + name + ''', Id, PostId,
  SUM(CASE value WHEN 0 THEN 0 ELSE 1 END)
FROM (
SELECT Id, PostId, ca1.value
  FROM ' + quotename(name) + '.dbo.PostHistory
  CROSS APPLY (
    SELECT PATINDEX(''%"Id":'' + CAST(UserId AS NVARCHAR) + '',%'', Text)
      AS value
      FROM #mods
      WHERE [database] = ''' + REPLACE(name, '.Meta', '') + '''
  ) ca1
  WHERE PostHistoryTypeId = 10
) AS subquery
GROUP BY Id, PostId
HAVING SUM(CASE value WHEN 0 THEN 0 ELSE 1 END) >= 3
'
from sys.databases
where database_id > 5

-- execute it
exec (@sql)

SELECT #results.name,
  CASE WHEN #sites.name IS NOT NULL
       THEN 'https://' + #sites.site + '/q/' + CAST(postid AS NVARCHAR)
  -- WARNING: ugly hack ahead
       ELSE 'Question ' + CAST(postid AS NVARCHAR) END,
  numberOfMods
  FROM #results LEFT OUTER JOIN #sites ON #results.name = #sites.name
  ORDER BY numberOfMods DESC, #sites.name, postid

DROP TABLE #results;
DROP TABLE #sites;
DROP TABLE #mods;

Enter Parameters

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