kat ufak yanlis

SQL

USE trwiki_p;
SELECT NOW();

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

SET @KAT = replace("Anlam ayrımı s"," ","_");
SELECT concat("tr.wikipedia.org/wiki?redirect=no&curid=",page_id) as url, page_title, page_is_redirect, page_latest,page_len,cl.cl_to
from categorylinks cl join page on page_id = cl.cl_from 
where cl.cl_to not rlike @KAT
and page_id in (select cl2.cl_from from categorylinks cl2 where cl2.cl_to rlike @KAT)
group by page_id
order by page_latest
;
SQL

Checking query status...
