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

SQL

use trwiki_p;
SELECT
  #imgtmp.page_namespace,
  concat("tr.wikipedia.org/wiki/",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 ("Tüm_adil_kullanım_dosyaları", "Adil_kullanım_sembolleri")
GROUP BY 
imgtmp.page_namespace,
imgtmp.page_title
HAVING COUNT(cl_to) > 1
ORDER BY COUNT(cl_to) DESC;

SQL

Checking query status...