editors who touched files with no license

SQL

SELECT actor_name, COUNT(*)
FROM revision_userindex
JOIN actor_revision ON rev_actor = actor_id
JOIN page ON rev_page = page_id
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"
WHERE
	page_namespace = 6
	AND flickr.cl_from IS NULL
    AND dt.tl_from IS NULL
    AND lt.tl_from IS NULL
GROUP BY actor_id
ORDER BY COUNT(*) DESC
SQL

Checking query status...
