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.