Untitled query #18170

SQL

USE trwiki_p;
SET @NS = 0;

select p.page_title, count(*), concat("tr.wikipedia.org/wiki?redirect=no&curid=",p.page_id) as url
-- ,concat('tr.wikipedia.org/w/index.php?title=Özel:SayfayaBağlantılar&target=Template:',replace(p.page_title,' ','+'),'&namespace=',@NS) as urlbag

from page p join templatelinks tl on tl.tl_title = p.page_title

where p.page_namespace = 10
and tl.tl_from_namespace = @NS
and tl.tl_namespace = 10
and p.page_id in (select tl2.tl_from from templatelinks tl2 join page p2 on p2.page_title = tl2.tl_title
                  where p2.page_is_redirect =1
                  and p2.page_namespace = 10
                  and tl2.tl_namespace =10
                  and tl2.tl_from_namespace =10
                  and tl2.tl_title not rlike "subpage"
                  and tl2.tl_title not rlike "belgesi"
                  and tl2.tl_title not in ('Dot', 'Loop', 'Spaces', 'T1')
                  )

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

Checking query status...
