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
Mr. Stradivarius
.
Toggle Highlighting
SQL
SELECT page_namespace, page_title FROM page WHERE page_namespace % 2 = 0 AND page_namespace != 0 AND page_namespace != 2 AND page_namespace != 8 AND NOT page_is_redirect AND page_title LIKE '%.js' AND NOT (page_namespace = 4 AND page_title LIKE 'Miscellany_for_deletion/%') AND NOT (page_namespace = 4 AND page_title LIKE 'Articles_for_deletion/%') AND NOT (page_namespace = 4 AND page_title LIKE 'WikiProject_Transwiki/%') AND NOT (page_namespace = 10 AND page_title LIKE 'Editnotices/%') AND NOT (page_namespace = 10 AND page_title LIKE '%/rater-data.js') AND NOT (page_namespace = 10 AND page_title LIKE 'Latest_stable_software_release/%') AND NOT EXISTS ( SELECT 1 from page_restrictions WHERE pr_page = page_id ) ORDER BY page_namespace, page_title;
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...