Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Untagged templates used in MediaWiki namespace
by
Pppery
This query is marked as a draft
This query has been published
by
Hidayatsrf
.
Toggle Highlighting
SQL
select distinct concat("* [[{{subst:ns:", tl_namespace, "}}:", tl_title, "]]") from templatelinks join page src on tl_from = src.page_id join page dst on tl_namespace = dst.page_namespace and tl_title = dst.page_title where src.page_namespace = 8 and not exists (select 1 from templatelinks tl2 where tl_from = dst.page_id and tl_title = "Used_in_system") and (dst.page_namespace = 10 or dst.page_namespace = 828) and src.page_title != "Deletedtext" and src.page_title != "Filedelete-success" /* these messages transclude their own talk page */ and src.page_title not like "Ffeed%" /* while templates used on the main page are protected, they don't need to be tagged as used in system, even though [[mw:Extension:FeaturedFeeds]] is installed */ and src.page_title != "Category-move-redirect-override" /* not a system message in the normal sense */ and src.page_title not like "Ipbreason-dropdown%" and src.page_title not like "Spam-%list/Indicators" and src.page_title != "Watcheditlist/Check_all" and src.page_title != "Noautocreatetext" /* Unused message? */ and src.page_title != "Noautocreatetext/en-CA" /* Sigh */ and src.page_title != "Abusefilter-warning-throttled" /* Disabled filter */ and src.page_title != "Abusefilter-warning-NoIPedits" /* Disabled filter */ and src.page_title != "Watchlist-messages" /* Too many false positives from documentation */ and src.page_content_model = "wikitext" and src.page_is_redirect = 0 and src.page_title != "Move-redirect-text" and dst.page_content_model != "sanitized-css" and dst.page_title not like "Documentation%" and dst.page_title != "Editnotices/Namespace/MediaWiki" and dst.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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...