Free non-free files

SQL

USE enwiki_p;
SELECT p.page_title FROM page p
INNER JOIN categorylinks c1 ON c1.cl_from = p.page_id AND c1.cl_to = 'All_free_media'
INNER JOIN categorylinks c2 ON c2.cl_from = p.page_id AND c2.cl_to = 'All_non-free_media'
#INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to IN ('All_free_media', 'All_non-free_media')
LEFT JOIN templatelinks t ON t.tl_from = p.page_id AND t.tl_namespace = 10 AND t.tl_title = 'Photo_of_art'
WHERE t.tl_from IS NULL
#GROUP BY p.page_id
#HAVING COUNT(*) = 2
SQL

Checking query status...
