bek azcok - Quarry

SQL

USE trwiki_p;
set now();
SEt @N = -50;
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
join user on user_name =r1.rev_user_text
where -- r1.rev_user > 0 and r2.rev_user > 0 and 
-- r1.rev_id < page_latest and 
r1.rev_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY)
and r2.rev_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY)
and r2.rev_user_text =  user_name
;
set now();
SQL

Checking query status...
