Commons images without license

Find Commons images without license, which are detected as images not transcluding [[template:License_template_tag]], nor tagged for deletion for lack of license.

SQL

USE commonswiki_p;
SELECT /* SLOW_OK */  concat("File:",page_title)
FROM page
WHERE page_namespace = 6       -- files only
AND page_is_redirect = 0       -- no redirects
AND NOT page_title LIKE "%/%"  -- no sub-pages
AND NOT exists (
    SELECT *
    FROM templatelinks
    WHERE tl_from=page_id 
    AND tl_namespace IN (10, 2)
    AND tl_title IN ("License_template_tag","Deletion_template_tag") -- find files that do not have a license and do not wait for deletion
	limit 1 
)
AND NOT exists ( -- find files that are not in "No license" categories
    SELECT *
    FROM categorylinks
    WHERE cl_from=page_id 
	AND cl_to IN ("Media_without_a_license:_needs_history_check", "New_uploads_without_a_license")
	limit 1 
)

SQL

Checking query status...