Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Retro
.
Toggle Highlighting
SQL
# Previous: # * "Danger" # * "icon" SET @in_string = "GA"; USE enwiki_p; SELECT * FROM page WHERE page_namespace = 10 AND page_title LIKE CONCAT("%", @in_string, "%") AND not_exists ( SELECT 1 FROM categorylinks WHERE cl_from = page_id AND cl_to NOT IN ( "Wikipedia_GA_templates", # Subcategories (I wonder if implicit checking is possible) "GA_discussion_templates", "GA_talk_message_boxes", "GA_user_talk_message_templates", "Good_content_user_templates" ) ) /* AND page_title NOT LIKE "Adminstats/%" AND page_title NOT LIKE "Did_you_know_nominations/%" AND page_title NOT LIKE "Editnotices/%" */
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...