bek az - Quarry

SQL

USE trwiki_p;

sELECT concat("[[:",page_title,"|",replace(page_title,"_"," "),"]]") as madde, rev_user_text as kullanici
,CONCAT("https://tr.wikipedia.org/w/index.php?diff=cur&oldid=",fpp_rev_id) as tumbekleyen
,CONCAT("https://tr.wikipedia.org/wiki/Özel:Diff/",rev_id) as ilkbekleyen
,DATEDIFF(NOW(),rev_timestamp) as gun
, count(*)

from flaggedpage_pending join page on  page_id = fpp_page_id
join revision_userindex on rev_parent_id = fpp_rev_id
where rev_id = page_latest
and page_namespace = 0
-- and rev_user > 0   -- sadece kayıtlı kullanıcılar için baştaki -- silinebilir
group by substring(rev_user_text,1,10)
order by count(*) desc,page_latest

;
SQL

Checking query status...
