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, ug_group, DATEDIFF(NOW(), last_edit) as gun
	FROM (SELECT *, MAX(rev_timestamp) AS last_edit FROM revision WHERE rev_user > 0 GROUP BY rev_user) AS latest
	JOIN user
		ON user_id = latest.rev_user
     JOIN user_groups
		ON ug_user = latest.rev_user
WHERE  user_editcount > 30
AND last_edit > DATE_ADD(NOW(), INTERVAL -100 DAY)
ORDER BY user_editcount DESC
LIMIT 200;

SQL

Checking query status...