bek az - Quarry

SQL

USE trwiki_p;
/*
SELECT cl_to, count(*)
from flaggedpage_pending join categorylinks on cl_from = fpp_page_id
where cl_to in (select pc.page_title from page pc join page_props on pp_page = pc.page_id 
              where pc.page_namespace = 14 and pp_propname in ("hiddencat"))
group by 1
having count(*) > 0
order by 2 desc
;
-- */
sELECT page_title, rev_user_text
,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

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 rev_user > 0
order by page_latest
-- limit 10
;
SQL

Checking query status...
