User:Legoktm/Liberation/Editinterface: Difference between revisions

From Wikimedia Foundation Governance Wiki
Content deleted Content added
Legoktm (talk | contribs)
start
 
Legoktm (talk | contribs)
remove former sysops
Line 13: Line 13:
| rev_user_text |
| rev_user_text |
+-------------------+
+-------------------+
| Angela |
| Looxix |
| Looxix |
| M7 |
| M7 |
| MediaWiki default |
| Miya |
| Miya |
| Kaganer |
| Kaganer |
| Cary Bass |
| MaxSem |
| MaxSem |
| Spacebirdy |
| Spacebirdy |

Revision as of 02:15, 27 January 2013

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.

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           |
+-------------------+