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

SQL

use lvwiki_p;
SELECT
  imgtmp.page_namespace,
  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 cl_to IN ("Aizsargāti_attēli", "Aizsargāti_logo", "Aizsargātas_pastmarkas",
"Aizsargāti_filmu_plakāti‎", "Aizsargāti_grāmatu_vāki‎",
"Aizsargāti_skaņas_faili‎", "Albuma_vāka_attēli‎", "Pastmarkas")
GROUP BY imgtmp.page_namespace, imgtmp.page_title
HAVING COUNT(cl_to) > 4
ORDER BY COUNT(cl_to) DESC;

SQL

Checking query status...