Disambiguation pages with categories on etwiki

SQL

USE etwiki_p;
SELECT CONCAT('[[',page_title,']]') AS page_title, cl_to, tl_title#, COUNT(*) AS count_cl_to
FROM page, categorylinks, templatelinks
WHERE page_id = cl_from
AND page_id = tl_from
AND page_namespace = 0
AND EXISTS
(SELECT *
FROM templatelinks AS t1
WHERE page_id = t1.tl_from
AND cl_to NOT LIKE '%äpsustusleheküljed' AND cl_to NOT LIKE '%oimetamist_ootavad%'
#AND p1.page_namespace = 14
)
AND EXISTS
(SELECT *
FROM categorylinks AS c1
WHERE page_id = c1.cl_from
 AND (tl_title LIKE '%äpsustuslehekülg' OR '%äpsustus')
AND tl_namespace = 10
#AND p1.page_namespace = 14
)
#GROUP BY page_title
ORDER BY page_title ASC
LIMIT 499;

SQL

Checking query status...