Fork of
Most used templates but not protected
by ASammour
This query is marked as a draft
This query has been published
by Geraki.
SQL
AخA
use elwiki_p;
select page_title from page
where (select count(*) from templatelinks where tl_title = page_title and tl_namespace = 10) > 5000
and (select count(*) from page_restrictions where pr_page = page_id) = 0
and page_namespace = 10
and page_is_redirect = 0
;
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.