kat ufak yanlis

SQL

USE trwiki_p;
SELECT NOW();

SELECT concat("tr.wikipedia.org/wiki?redirect=no&curid=",page_id) as url, page_namespace, 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 and page_namespace > -1
group by page_id
order by cl_to, page_namespace, page_len, page_latest
;
/*
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 cl.cl_to not in ("ISBN_sihirli_bağlantısını_kullanan_sayfalar","Türkçe_soyadları")
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...
