SQL
AخA
/*
select count(*) from page where page_namespace = 1 and page_is_redirect = 0
and page_title in (select page_title from page where page_namespace = 0 and page_is_redirect = 1)
and page_len = 0
*/
select count(tl_from) from templatelinks where tl_target_id in (
select lt_id from linktarget
where lt_title in ('WikiProject_banner') and lt_namespace = 828 or lt_title in ('WPBannerMeta') and lt_namespace = 10
)
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.