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();