SQL
AخA
USE commonswiki_p;
SELECT CONCAT ('[[:File:', REPLACE (page_title,'_',' '), ']]') AS filelist FROM page
#SELECT CONCAT ('[[', REPLACE (page_title,'_',' '), ']]') AS filelist FROM page
INNER JOIN categorylinks ON cl_from = page_id
WHERE page_namespace = 6 #0
#AND cl_to = 'Images_from_the_State_Records_Authority_of_New_South_Wales'
#AND cl_to = 'Redirects_connected_to_a_Wikidata_item'
#AND cl_to = 'Topographia_Circuli_Burgundici_(Merian)'
#AND cl_to = 'Media_needing_category_review_where_timestamp_category_does_not_exist'
#AND cl_to = 'Redundant_media_renaming_requests'
AND cl_to = 'Files_with_no_machine-readable_license'
AND page_is_redirect = 1
LIMIT 5000;
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.