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 r2.rev_user > 0
and r1.rev_id < page_latest and r1.rev_timestamp>dateadd(now(), -50 DAY)
and and r2.rev_timestamp>dateadd(now(), -50 DAY)
and r2.rev_user =  r1.rev_user


;
SQL

Checking query status...
