Fork of
Untitled query #6036
by Sfan00 IMG
This query is marked as a draft
This query has been published
by ShakespeareFan00.
SQL
x
USE enwiki_p;
SELECT p.page_id,p.page_title FROM page p
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'All_free_in_US_media'
LEFT JOIN templatelinks t ON t.tl_from = p.page_id AND t.tl_namespace = 10 AND t.tl_title IN
(
## Commons related
#'ShadowsCommons',
'Now_Commons',
## Keep local
# 'Keep_local',
## local deltion process
'Db-meta', 'Deletable_file','Duplicate','Ffd', 'File_at_CCI', 'Puf',
## Protected
'Pp', 'Pp-template', 'Protected_generic_image_name', 'Protected_sister_project_logo',
## Files that are deemed to be self-made
'Self','PD-self', 'GFDL-self', 'GFDL-self-with-disclaimers', 'Multilicense_replacing_placeholder_new',
## featured content
'FeaturedPicture', 'Featured_Picture', 'Former_featured_picture', 'Featured_sound',
## OTRS
'OTRS_pending', 'OTRS_received',
## Non-free media
'NFUR_not_needed', 'Non-free_media',
## "What we want, No 6."
'Information','Image_information_art','Google_Art_Project', 'Painting',
## Misc
'DYKfile',
#'Esoteric_file',
#'Example_files',
'Uploaded_from_Commons',
'M-cropped',
'Split_media'
## 'Wikipedia-screenshot'
## For Manual review.
# 'Out_of_copyright_in',
#'PD-US-1923-abroad',
#'PD-ineligible-USonly'
)
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.
All SQL code is licensed under CC0 License.