bek az - Quarry

SQL

USE trwiki_p;
SET @M = 10;
SELECT *, concat("tr.wikipedia.org/wiki?redirect=no&curid=",fpp_page_id), page_is_redirect, page_latest,page_len
from flaggedpage_pending  join page on page_id = fpp_page_id
where not exists (select * from categorylinks where cl_from = fpp_page_id);

SELECT concat("tr.wikipedia.org/wiki?redirect=no&curid=",page_id), page_is_redirect, page_latest,page_len,cl_to  
from categorylinks  join page on page_id = cl_from 
where page_is_redirect = 1 -- group by page_id order by page_latest
;


SELECT cl_to, count(*)
from flaggedpage_pending join categorylinks on cl_from = fpp_page_id
where cl_to in (select pc.page_title from page pc join page_props on pp_page = pc.page_id 
              where pc.page_namespace = 14 and pp_propname in ("hiddencat"))
group by 1
having count(*) > @M
order by 2 desc
;

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
,rev_timestamp
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 rev_user = 0
order by page_latest
limit 300
;
SQL

Checking query status...
