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
;

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 "Anlam ayrımı"
and exists (select * from categorylinks cl2 where cl2.cl_to = "Anlam ayrımı sayfaları" and cl2.cl_from = page_id)
SQL

Checking query status...
