SQL
x
SELECT DISTINCT p.page_id, r.rev_id, CONCAT("File:", p.page_title) FROM page p
JOIN revision r ON r.rev_page = p.page_id AND r.rev_user = 4906524
JOIN templatelinks t1 ON t1.tl_from = p.page_id AND t1.tl_title = 'Information' AND t1.tl_namespace = 10
LEFT JOIN templatelinks t2 ON t2.tl_from = p.page_id AND t2.tl_title IN (
## Known self templates ##
'PD-self',
'Self',
'GFDL-self',
'Multilicense_replacing_placeholder_new',
## Known issue, in process etc.
'Ffd',
'Puf',
'Deletable_file',
'Now_Commons',
'Esoteric_file',
'Non-free_use_rationale',
'Userspace_file',
'Split_media',
'PD-because',
'OTRS_pending',
'NFUR_not_needed',
'PermissionOTRS',
'OTRS_permission',
'Assumed_license',
'Media_by_uploader',
'Presumed_self',
'Presumed_self',
## Known tags
## USGov
'PD-LosAlamos',
'PD-NWS',
'PD-OakRidge',
'PD-USGov',
'PD-USGov-AID',
'PD-USGov-Atlas',
'PD-USGov-Award',
'PD-USGov-CIA',
'PD-USGov-CIA-WF',
'PD-USGov-Congress',
'PD-USGov-Congress-AOC',
'PD-USGov-Courts',
'PD-USGov-DEA',
'PD-USGov-DHS',
'PD-USGov-DHS-CG',
'PD-USGov-DHS-FEMA',
'PD-USGov-DOC',
'PD-USGov-DOC-Census',
'PD-USGov-DOC-NOAA',
'PD-USGov-DOE',
'PD-USGov-DOE-ANL',
'PD-USGov-DOJ',
'PD-USGov-DOL',
'PD-USGov-DOT',
'PD-USGov-DOT-FAA',
'PD-USGOV-DVIC',
'PD-USGov-Education',
'PD-USGov-EPA',
'PD-USGov-FBI',
'PD-USGov-FCC',
'PD-USGov-FDA',
'PD-USGov-Fed',
'PD-USGov-FSA',
'PD-USGov-FTC',
'PD-USGov-GAO',
'PD-USGov-GPO',
'PD-USGov-GSA',
'PD-USGov-HHS',
'PD-USGov-HHS-CDC',
'PD-USGov-HHS-NIH',
'PD-USGov-Interior',
'PD-USGov-Interior-BLM',
'PD-USGov-Interior-FWS',
'PD-USGov-Interior-HABS',
'PD-USGov-Interior-MMS',
'PD-USGov-Interior-NPS',
'PD-USGov-Interior-USBR',
'PD-USGov-Interior-USGS',
'PD-USGov-Interior-USGS-Minerals',
'PD-USGov-Military',
'PD-USGov-Military-Air_Force',
'PD-USGov-Military-Air-National-Guard',
'PD-USGov-Military-Army',
'PD-USGov-Military-Army National Guard',
'PD-USGov-Military-Army-USACE',
'PD-USGov-Military-Army-USACMH',
'PD-USGov-Military-Army-USAIOH',
'PD-USGov-Military-Army-USAMHI',
'PD-USGov-Military-Award',
'PD-USGov-Military-Badge',
'PD-USGov-Military-DVIC',
'PD-USGov-Military-JCS',
'PD-USGov-Military-Marines',
'PD-USGov-Military-MDA',
'PD-USGov-Military-Navy',
'PD-USGov-money',
'PD-USGov-MUTCD',
'PD-USGov-NASA',
'PD-USGov-NCBI-scienceprimer',
'PD-USGov-NEA',
'PD-USGov-NRC',
'PD-USGov-NRO',
'PD-USGov-NSA',
'PD-USGov-NSF',
'PD-USGov-NTSB',
'PD-USGov-OWI',
'PD-USGov-PHS',
'PD-USGov-POTUS',
'PD-USGov-pre1978stamp',
'PD-USGov-SEC',
'PD-USGov-SI',
'PD-USGov-SSA',
'PD-USGov-State',
'PD-USGov-Treasury',
'PD-USGov-TVA',
'PD-USGov-USDA',
'PD-USGov-USDA-AMS',
'PD-USGov-USDA-ARS',
'PD-USGov-USDA-FAS',
'PD-USGov-USDA-FS',
'PD-USGov-USDA-NAL',
'PD-USGov-USDA-NRCS',
'PD-USGov-VA',
'PD-USGov-VOA',
'PD-USGov-WPA',
'PD-WorldWind',
##us
'PD-1923',
##age
'PD-old',
'PD-old-100','PD-old-70',
'PD-art',
'PD-art-3d',
'PD-US-not renewed',
## PD-ineligible
'PD-ineligible',
'PD-ineligible-USonly',
'PD-textlogo',
'PD-text',
'PD-simple',
'PD-logo',
## PD Geographic
'PD-Russia-2008',
'PD-USonly',
'PD-US-1923-abroad',
'PD-Italy',
'PD-US',
'PD-UK',
'PD-NZ',
'PD-UK',
'PD-UKGov',
'PD-Canada',
'PD-India',
'PD-Australia',
'PD-AustraliaGov',
'PD-Poland',
## Self
'PD-self',
'GFDL-self',
'GFDL-self-with-disclaimers',
'self'
) AND t2.tl_namespace = 10
WHERE p.page_namespace = 6
AND t2.tl_from IS NULL
AND ( r.rev_comment = 'adding {{Information}}; adding using [[Wikipedia:FurMe|FurMe]]'
OR r.rev_comment = 'adding {{Information}}; using [[Wikipedia:FurMe|FurMe]]'
OR r.rev_comment = 'adding {{Information}} using [[Wikipedia:FurMe|FurMe]]'
OR r.rev_comment = 'adding {{Information}}; adding {{Copy to Wikimedia Commons}} using [[Wikipedia:FurMe|FurMe]]' )
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.