Overused non-free files (lvwiki)

SQL

USE lvwiki_p;
SELECT
  concat("[[:Attēls:",REPLACE(page_title, '_', ' '),"]]"),
  COUNT(*)
FROM imagelinks
JOIN (SELECT
        page_id,
        page_title
      FROM page
      JOIN categorylinks
      ON cl_from = page_id
      WHERE 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")
      AND page_namespace = 6) AS pgtmp
ON pgtmp.page_title = il_to
GROUP BY il_to
HAVING COUNT(*) > 4
ORDER BY COUNT(*) desc;
SQL

Checking query status...
