Untitled query #17445

SQL

use lvwiki_p;
SELECT
  page_title,
  ppp1.page_namespace, ppp1.page_title
FROM imagelinks
join page ppp1 on il_from=ppp1.page_title
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...
