Untitled query #21878

SQL

USE trwiki_p;

select concat("http://tr.wikipedia.org/wiki/Kategori:",cl_to), 
replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
  replace(left(cl_to,30),"'","")
  ,"ğ","g"),"Ğ","G"),"ş","s"),"Ş","S"),"ı","i"),"İ","I"),"ç","c"),"Ç","C"),"ü","u"),"ö","o"),"Ü","U"),"Ö","O")
                ,"î","i"),"â","a") 
as bas
, count(*) as ccc

from categorylinks
where cl_type = "page" and cl_to not in (select page_title from page where page_namespace = 14)

group by bas
order by ccc desc
;
SQL

Checking query status...
