This query is marked as a draft This query has been published by Zygimantus.

SQL

AخA
 
use ltwiki_p;
select
  CONCAT('[[',pl.pl_title,']]') AS "Title",
  COUNT(pl.pl_title) AS "Links count"
from pagelinks pl
where
pl.pl_title IN (Select page_title from page where page_namespace=0) and pl.pl_from_namespace=0 and pl.pl_namespace=0
and pl.pl_title NOT IN 
(
select pl_title
from pagelinks pl
left join page p on pl.pl_from=p.page_id
where 
page_namespace=10 and pl_from IN (select tl_from
from templatelinks
where
tl_from_namespace=10)
and pl_namespace=0
)
group by pl.pl_title
having COUNT(pl.pl_title)>10
order by COUNT(pl.pl_title) DESC
LIMIT 1000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...