Utilisateur:Bloody-libu/Non-free files used outside articles (fr)
Non-free files used outside articles (fr)
USE frwiki_p; SELECT DISTINCT CONCAT('*[[:File:', p.page_title, ']]') FROM page p INNER JOIN categorylinks c ON p.page_id = c.cl_from INNER JOIN (imagelinks i LEFT JOIN redirect r ON i.il_from = r.rd_from) ON p.page_title = i.il_to WHERE c.cl_to = "Wikipédia:Exceptions_au_droit_d'auteur" AND i.il_from_namespace != 0 AND r.rd_from IS NULL ORDER BY p.page_title ASC;