False {{used in system}}

SQL

select dst.page_namespace, dst.page_title from templatelinks
join linktarget on lt_id=tl_target_id
join page dst on page_id=tl_from
where lt_title = "Used_in_system"
and lt_namespace = 10
and (dst.page_namespace = 10 or dst.page_namespace = 828)
and not exists (select 1 from templatelinks tl2 join linktarget lt2 on lt2.lt_id=tl2.tl_target_id
                join page src on tl_from=src.page_id 
where lt2.lt_namespace = dst.page_namespace
and lt2.lt_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"
and dst.page_title != "Display/watchlist"
-- - Only used during ACE elections
and dst.page_title != "Interval"
and dst.page_title != "Arbitration_Committee_candidate/data"
-- - Only used when an RfA is running
and dst.page_title != "Number_to_word"
and dst.page_title != "ConvertNumeric"
and dst.page_title != "RfA_watchlist_notice/text"
-- - I assume the Arbitration Committee knows what it's doing ...
and dst.page_title != "Contentious_topics/alert"
-- Mainspace editintro stuff
and dst.page_title != "Mainspace_editnotice"
and dst.page_title != "Disambiguation"
and dst.page_title != "Mainspace_editnotice"
and dst.page_is_redirect=0
and dst.page_title not like "Editnotices/Page/Template:Contentious_topics/alert%"
SQL

Checking query status...
