Untitled query #18854

SQL

USE trwiki_p;
SET @nsf = 0;
SET @nst = 10;
SET @nn = 10-@nst;
select tl_title,tl_namespace, count(*) as ec, concat("tr.wikipedia.org/wiki/Şablon:",tl_title) as url
from templatelinks

where tl_title in (select pt.page_title from page ptt join pagelinks ptl on ptl.pl_title = ptt.page_title  
                   join page pt on ptl.pl_from = pt.page_id where ptt.page_is_redirect = 1
                   and pt.page_namespace = 10 and ptt.page_namespace = @nsf and ptl.pl_namespace = @nsf
                   and ptl.pl_from_namespace = 10
                   )
and tl_namespace = 10 
and tl_from_namespace = @nst
group by tl_from having count(*)>@nn
order by count(*) desc

;
SQL

Checking query status...
