files with no license

SQL

SELECT CONCAT("File:", page_title)
FROM page
JOIN image ON page_title = img_name
JOIN categorylinks nol ON nol.cl_from = page_id AND nol.cl_to = "Files_with_no_machine-readable_license"
LEFT JOIN categorylinks flickr ON flickr.cl_from = page_id AND flickr.cl_to = "Flickr_public_domain_images_needing_specific_copyright_tags"
LEFT JOIN templatelinks dt ON dt.tl_from = page_id AND dt.tl_namespace = 10 AND dt.tl_title = "Deletion_template_tag"
LEFT JOIN templatelinks lt ON lt.tl_from = page_id AND lt.tl_namespace = 10 AND lt.tl_title = "License_template_tag"
LEFT JOIN categorylinks ma ON ma.cl_from = page_id AND ma.cl_to = "Public domain files with no author lifetime information"
WHERE
	page_namespace = 6
	AND flickr.cl_from IS NULL
    AND dt.tl_from IS NULL
    AND lt.tl_from IS NULL
    AND ma.cl_from IS NULL
SQL

Checking query status...
