trwiki:Disambiguation pages with categories

Fork of Disambiguation pages with categories on plwiki by The Polish

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

SQL

USE plwiki_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 'Anlam_ayrımı_sayfaları'
#AND p1.page_namespace = 14
)
AND EXISTS
(SELECT *
FROM categorylinks AS c1
WHERE page_id = c1.cl_from
AND tl_title LIKE 'Anlam_ayrımı'
AND tl_namespace = 10
#AND p1.page_namespace = 14
)
#GROUP BY page_title
ORDER BY page_title ASC;

SQL

Checking query status...