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
Stefan2
.
https://en.wikipedia.org/w/index.php?title=User_talk:Stefan2&diff=684498997&oldid=684497145
Toggle Highlighting
SQL
USE enwiki_p; SELECT p.page_title FROM page p INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'All_free_media' LEFT JOIN templatelinks t ON t.tl_from = p.page_id AND t.tl_namespace = 10 AND t.tl_title IN ('!Copy_to_Wikimedia_Commons', 'Bsr', 'Convert_to_SVG_and_copy_to_Wikimedia_Commons', 'Copy_to_Wikimedia_Commons', 'DYKfile', 'Db-meta', 'Deletable_file', 'Deleted_on_Commons', 'Do_not_move_to_Commons', 'Duplicate', 'Esoteric_file', 'Example_files', 'Ffd', 'File_at_CCI', 'Former_featured_picture', 'Imagewatermark', 'Incomplete_move_to_Commons', 'Information', 'Keep_local', 'M-cropped', 'NFUR_not_needed', 'Nominated_for_deletion_on_Commons', 'Non-free_media', 'Now_Commons', 'OTRS_pending', 'OTRS_received', 'Out_of_copyright_in', 'Pp', 'Pp-template', 'Protected_generic_image_name', 'Protected_sister_project_logo', 'Puf', 'ShadowsCommons', 'Split_media', 'Uploaded_from_Commons', 'Wikipedia-screenshot', 'Wrong-license', 'Self') WHERE t.tl_from IS NULL AND p.page_namespace = 6
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...