Untitled query #17445

SQL

use lvwiki_p;
SELECT
  pgtmp.page_title,
  ppp1.page_namespace, ppp1.page_title
FROM imagelinks
join page ppp1 on il_from=ppp1.page_title
JOIN (SELECT
        p1.page_id,
        page_title
      FROM page p1
      JOIN categorylinks
      ON cl_from = p1.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 p1.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...
