bek azcok - Quarry

SQL

USE trwiki_p;
select now();
SEt @N = -50;
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
-- */ select *
from flaggedpage_pending join page on  page_id = fpp_page_id
join revision_userindex  on rev_parent_id = fpp_rev_id
join recentchanges_userindex on rc_this_oldid = page_latest
where  rc_type = 0
and rev_user > 0 and rc_user > 0  
and rev_id < page_latest  
and rev_timestamp > DATE_ADD(NOW(), INTERVAL @N DAY)
and rev_user =  rc_user
--  */limit 10
;
select now();
SQL

Checking query status...
