Pages containing an unusually high number of non-free files (fr)

SQL

use frwiki_p;
SELECT
  #imgtmp.page_namespace,
  concat("[[",REPLACE(imgtmp.page_title, '_', ' '),"]]"),
  COUNT(cl_to)
FROM page AS pg1
JOIN categorylinks
ON cl_from = pg1.page_id
JOIN (SELECT
        pg2.page_namespace,
        pg2.page_title,
        il_to
      FROM page AS pg2
      JOIN imagelinks
      ON il_from = page_id) AS imgtmp
ON il_to = pg1.page_title
WHERE pg1.page_namespace = 6 and imgtmp.page_namespace=0
AND cl_to IN ("Wikipédia:Exceptions_au_droit_d'auteur")
GROUP BY 
imgtmp.page_namespace,
imgtmp.page_title
HAVING COUNT(cl_to) > 10
ORDER BY COUNT(cl_to) DESC;

SQL

Checking query status...