for autoreview or blocking on trwiki

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.

SQL

USE trwiki_p;
SELECT user_name, last_edit, user_editcount
	FROM (SELECT rev_user, MAX(rev_timestamp) AS last_edit FROM revision WHERE rev_user > 0 AND last_edit > DATE_ADD(NOW(), INTERVAL -100 DAY)
          GROUP BY rev_user) AS latest
          JOIN user ON user_id = latest.rev_user
          
where user_editcount > 30
ORDER BY last_edit DESC
LIMIT 200;

SQL

Checking query status...