bek az - Quarry

SQL

USE trwiki_p;
SET @N = 10;

SELECT group_concat(concat("[[:",page_title,"|",replace(page_title,"_"," "),"]]")) as madde, rev_user_text as kullanici
,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
,
 count(*), sum(
   DATEDIFF(NOW(),rev_timestamp)
              ) 
              as gun

from flaggedpage_pending join page on  page_id = fpp_page_id
join revision_userindex on rev_parent_id = fpp_rev_id
where rev_id = page_latest
and page_namespace = 0
and DATEDIFF(NOW(),rev_timestamp) > @N
-- and rev_user > 0   -- sadece kayıtlı kullanıcılar için baştaki -- silinebilir
group by substring(rev_user_text,1,10) having count(*)>1
order by gun desc,page_latest
;

SELECT (concat("[[:",page_title,"|",replace(page_title,"_"," "),"]]")) as madde, rev_user_text as kullanici
,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

from flaggedpage_pending join page on  page_id = fpp_page_id
join revision_userindex on rev_parent_id = fpp_rev_id
where rev_id = page_latest
and page_namespace = 0
and DATEDIFF(NOW(),rev_timestamp) > @N
-- and rev_user > 0   -- sadece kayıtlı kullanıcılar için baştaki -- silinebilir
group by substring(rev_user_text,1,10) having count(*)=1
order by gun desc,page_latest
;
SQL

Checking query status...
