User:Legoktm/Liberation/Editinterface

From the Wikimedia Foundation Governance Wiki
Jump to navigation Jump to search

Currently all users can edit the MediaWiki namespace. This is a list of all users who are not sysops on this wiki but have edited the MediaWiki namespace. Users who were previously sysops should be removed from the list.

mysql> /* SLOW_OK */
    -> SELECT
    ->  rev_user_text
    -> FROM revision
    -> JOIN page ON rev_page = page_id
    -> WHERE page_namespace = 8
    -> AND NOT EXISTS ( SELECT * FROM user_groups WHERE ug_user=rev_user AND ug_group="sysop" )
    -> GROUP BY rev_user;
+-------------------+
| rev_user_text     |
+-------------------+
| Looxix            |
| M7                |
| Miya              |
| Kaganer           |
| MaxSem            |
| Spacebirdy        |
| Meno25            |
| MBisanz           |
| SPQRobin          |
| Nemo bis          |
| Odder             |
| Waldir            |
| PhiLiP            |
| Kwj2772           |
| Church of emacs   |
| Amire80           |
| Azariv            |
| Steven (WMF)      |
| JSeddon           |
| Jsoby             |
| Mono              |
| Emperyan          |
| Hwalls            |
| Krinkle           |
| Chadspencer       |
| MWalker           |
| Legoktm           |
+-------------------+