bek azcok - Quarry

SQL

USE trwiki_p;
sELECT page_title, r1.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/",r1.rev_id) as ilkbekleyen
,DATEDIFF(NOW(),r1.rev_timestamp) as gun

from flaggedpage_pending join page on  page_id = fpp_page_id
join revision_userindex r1 on r1.rev_parent_id = fpp_rev_id
join revision_userindex r2 on r2.rev_id = page_latest
where r1.rev_user > 0 
and r1.rev_user = r2.rev_user
and r1.rev_id < page_latest
order by page_latest
limit 10
;
SQL

Checking query status...
