Untitled query #21423

Fork of Disambiguation pages with categories on etwiki by Estopedist1

This query is marked as a draft This query has been published by Estopedist1.

SQL

USE etwiki_p;
SELECT CONCAT('[[',page_title,']]') AS page_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 'Täpsustusleheküljed' AND cl_to NOT LIKE 'Toimetamist_ootavad%'
#AND p1.page_namespace = 14
)
AND EXISTS
(SELECT *
FROM categorylinks AS c1
WHERE page_id = c1.cl_from
AND tl_title LIKE 'Täpsustuslehekülg' OR 'Täpsustus'
AND tl_namespace = 10
#AND p1.page_namespace = 14
)
#GROUP BY page_title
ORDER BY page_title ASC
LIMIT 500

SQL

Checking query status...