SQL
AخA
USE frwiki_p;
SELECT CONCAT('File:', p.page_title) FROM page p
INNER JOIN categorylinks c1 ON p.page_id = c1.cl_from
LEFT JOIN imagelinks i ON p.page_title = i.il_to AND (i.il_from_namespace = 0)
LEFT JOIN categorylinks c2 ON p.page_id = c2.cl_from AND c2.cl_to = "Maintenance_des_fichiers"
WHERE c1.cl_to = "Wikipédia:Exceptions_au_droit_d'auteur"
AND i.il_from IS NULL
AND c2.cl_from IS NULL
AND p.page_namespace = 6
ORDER BY p.page_title ASC;
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.