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 nor rlike "ablon"
                  )

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

Checking query status...
