ip - Quarry

SQL

USE trwiki_p;

SELECT  rc_user_text, count(*) as ec, concat("tr.wikipedia.org/wiki/Özel:Katkılar/",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(sign(rc_deleted))/count(*),2) as del, round(sum(rc_patrolled)/count(*),2) as pat
, round(sum(sign(rc_namespace))/count(*),4) as ns
, ddd.sayi
from recentchanges_userindex rc 
left join (select pp.page_title as ad, count(*) as sayi
  from page pp join revision_userindex as rev on rev.rev_page= pp.page_id
           where pp.page_namespace=3 and rev.rev_user = 104002
           group by pp.page_title
  ) as ddd on ddd.ad = rc_user_text
where rc_user = 0 and rc_bot = 0 and rc_type < 5
-- and rc_deleted = 1
-- and rc_timestamp
group by rc_user_text
having count(*) > 10
order by ddd.sayi, count(*) desc
;
SQL

Checking query status...
