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
Pppery
.
Toggle Highlighting
SQL
select dst.page_namespace, dst.page_title from templatelinks join page dst on page_id=tl_from where tl_title = "Used_in_system" and tl_namespace = 10 and (dst.page_namespace = 10 or dst.page_namespace = 828) and not exists (select 1 from templatelinks tl2 join page src on tl_from=src.page_id where tl2.tl_namespace = dst.page_namespace and tl2.tl_title = dst.page_title and src.page_namespace=8 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_content_model = "wikitext" and src.page_is_redirect = 0 and src.page_title != "Move-redirect-text" ) and dst.page_title not like "%/sandbox" and dst.page_title not like "%/testcases" and dst.page_title not like "%/doc" -- Known false positives and dst.page_title != "Used_in_system" and dst.page_title not like "Script_doc_auto%" and dst.page_title != "Module_sandbox_notice" and dst.page_title not like "Protected_page_text%" and dst.page_title != "Did you mean box" and dst.page_title != "Broken_ref/cat" and dst.page_title != "No_article_text/sister_projects" and dst.page_title != "Jf-JSON" -- - Only used during ACE elections and dst.page_title != "Interval" -- - Only used when an RfA is running and dst.page_title != "Number_to_word" and dst.page_title != "ConvertNumeric" -- - I assume the Arbitration Committee knows what it's doing ... and dst.page_title != "Ds/alert" and dst.page_title != "Editnotices/Page/Template:Ds/alert"
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...