Untitled query #17445

SQL

use lvwiki_p;
SELECT
  imgtmp.page_title,
  group_concat(pg1.page_title separator '|')
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 ("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(pg1.page_title) > 2
ORDER BY COUNT(pg1.page_title) DESC;
SQL

Checking query status...
