ip - Quarry

SQL

USE trwiki_p;

SELECT  rc_user_text, count(*), concat("tr.wikipedia.org/wiki/%C3%96zel:Katk%C4%B1lar/",rc_user_text) as katk
, round(sum(abs(rc_new_len - rc_old_len))/count(*),2) as ort_abs_kat,round(sum((rc_new_len - rc_old_len))/count(*),2) as ort_kat
,round(sum(rc_deleted)/count(*),2) as del, round(sum(rc_patrolled)/count(*),2) as pat
, round(sum(sign(rc_namespace))/count(*),4) as ns
from recentchanges_userindex rc 
where rc_user = 0 and rc_bot = 0 and rc_type < 5
and rc_deleted = 1
-- and rc_timestamp
group by rc_user_text
order by count(*) desc
limit 5
;
SQL

Checking query status...
