Untitled query #18854

SQL

USE trwiki_p;
SET @nsf = 0;
SET @nst = 0;
select *, count(*), concat("tr.wikipedia.org/wiki/Şablon:",tl_title) as url
from 
(select page_id as id
-- , page_title, page_latest, page_len
-- , count(*)
from pagelinks join page on page_title = pl_title

where pl_from_namespace = @nsf and pl_namespace = @nst and page_namespace = @nst 
and page_is_redirect = 1

group by page_id having count(*)>100
) as redo
join templatelinks on tl_from - redo.id
where tl_from_namespace = @nsf

group by tl_title having count(*) > 1
order by count(*) desc
;
SQL

Checking query status...
