User:Legoktm/Liberation/Editinterface: Difference between revisions
< User:Legoktm | Liberation
Content deleted Content added
start |
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 | +-------------------+