Bekleyen değişiklikler için

SQL

USE trwiki_p;

SELECT cl_to, count(*)
from flaggedpage_pending join categorylinks on cl_from = fpp_page_id
join page pc on pc.page_title = cl_to 

where pc.page_namespace = 14 and pc.page_id not in (select pp_page from page_props where pp_propname in ("hiddencat") )
and cl_to not rlike "taslakları"
group by 1
having count(*) > 80
order by 2 desc
;

SELECT concat("[[",replace(page_title,"_"," "),"]]") as madde, concat("http://tr.wikipedia.org/wiki?curid=",cl_from) as url
,concat("[[:Kategori:",cl_to,"|",replace(cl_to,"_"," "),"]]") as kat
, floor(fpp_pending_since/1000000) as tarih
, DATEDIFF(NOW(),fpp_pending_since) as kac_gun
from categorylinks join page on page_id = cl_from 
join flaggedpage_pending on fpp_page_id = cl_from 
where cl_to in ("Türk_erkek_dizi_oyuncuları", "Türk_kadın_dizi_oyuncuları")
and page_namespace = 0

order by tarih
;
SQL

Checking query status...
