USE trwiki_p;

SELECT NOW() as guncelleme_zamani;

​

SELECT CONCAT("[[Kullanıcı:",user_name,"|",user_name,"]]") AS kullanici, date_format(str_to_date(last_edit, '%Y%m%d%H%i%s'), '%e %M %Y %H:%i') AS son_katki, saysay as katki_sayisi_100, 

      user_editcount AS katki_sayisi_toplam, date_format(str_to_date(user_registration, '%Y%m%d%H%i%s'), '%e %M %Y') AS kullanici_kayit_tarihi, ufg_group as eski_grup, 

CONCAT("[[Özel:Katkılar/", user_name,"]]") AS link

    FROM (SELECT rev_user, COUNT(rev_timestamp) AS saysay, MAX(rev_timestamp) AS last_edit FROM revision WHERE rev_user > 0 AND rev_timestamp > DATE_ADD(NOW(), 

              INTERVAL -100 DAY) GROUP BY rev_user) AS latest

          JOIN user ON user_id = latest.rev_user

          LEFT JOIN user_groups ON ug_user = latest.rev_user

          LEFT JOIN ipblocks ON ipb_user = latest.rev_user

          LEFT JOIN user_former_groups ON ufg_user = latest.rev_user

WHERE ipb_user IS NULL

AND ug_user IS NULL

AND user_editcount > 30

AND user_registration < date_add(now(), INTERVAL -7 day)

AND user_name NOT LIKE '%Bot'

AND user_name NOT LIKE '%BOT'

ORDER BY ufg_group, saysay DESC, user_editcount DESC

LIMIT 500;

SELECT NOW();