Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Redirects hiding Commons files V2 - No more :(
by
KylieTastic
This query is marked as a draft
This query has been published
by
ShakespeareFan00
.
Redirects hiding Commons files V2
Toggle Highlighting
SQL
SELECT CONCAT ('File:',w.page_title) as page_title FROM enwiki_p.page w INNER JOIN commonswiki_p.page c ON c.page_title = w.page_title INNER JOIN enwiki_p.templatelinks tl ON tl.tl_from = w.page_id AND tl.tl_namespace = 10 AND tl.tl_title IN ( 'R_from_move' ) LEFT JOIN enwiki_p.templatelinks tx ON tx.tl_from = w.page_id AND tx.tl_namespace = 10 AND tx.tl_title IN ( 'db-redircom' ) WHERE w.page_namespace = 6 AND w.page_is_redirect = 1 AND c.page_namespace = 6 AND c.page_is_redirect = 0 AND tx.tl_from IS NULL
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...