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("[[",page_title,"]]") as madde, concat("http://tr.wikipedia.org/wiki?curid=",cl_from) as url
,concat("[[:Kategori:",cl_to,"|",cl_to,"]]") as kat
, count(*) as degisiklik_sayisi
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_erkek_dizi_oyuncuları")
and page_namespace = 0

group by cl_from

;
SQL

Checking query status...
