kat ufak yanlis

SQL

USE trwiki_p;
select concat("tr.wikipedia.org/wiki?curid=",cp.fr) as url, pc.ad, pc.r, concat("tr.wikipedia.org/wiki/Özel:Diff/",pc.l) as ll,cp.ts, count(*)
              from(
select left(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(LOWER(CONVERT(p.page_title USING UTF8))
                                                       ,"""",""),"'",""),".",""), "°",""), "-",""), ",","")
                               ,"ı","i"),"ş","s"), "ğ","g"), "ç","c"), "á","a"),20) as lad
, p.page_title as ad, p.page_id as id, p.page_is_redirect as r, p.page_latest as l from
page p where p.page_namespace = 14 
  ) as pc
  join (
    select left(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(LOWER(CONVERT(cl_to USING UTF8))
                                                       ,"""",""),"'",""),".",""), "°",""), "-",""), ",","")
                               ,"ı","i"),"ş","s"), "ğ","g"), "ç","c"), "á","a"),20)  as clad
, cl_from as fr, cl_timestamp as ts from categorylinks 
    
    where cl_type ="page" and left(cl_to,20) not in (select left(cp.page_title,20) from page cp where cp.page_namespace = 14 and cp.page_is_redirect = 0)
) as cp on cp.clad = pc.lad    
group by cp.fr
  limit 1000
;
SQL

Checking query status...
