Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Bulgu
.
Lists the non-blocked registered users on trwiki not attached to any user groups (such as sysop). The users that have never been part of any user group will be listed on top sorted according to their number of contributions in the last 100 days. The columns are for user names, last contribution date, #contributions in the last 100 days, total # contributions, user registration date, former user groups, link to wiki user contribution page. Beyaz listeye ekleme ya da engellemede faydalı olsun diye yapılmıştır. Engellenmemiş kayıtlı kullanıcıları listeler. Hiç bir zaman bir kullanıcı grubuna dahil olmamış kullanıcılar üstte, son 100 günde yaptıkları toplam değişiklik sayısına göre sıralanır.
Toggle Highlighting
SQL
USE trwiki_p; SELECT * FROM user, user_groups where user_id=Bulgu;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...