Disambiguation pages with categories on trwiki

Fork of Disambiguation pages with categories on etwiki by Estopedist1

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

SQL

USE trwiki_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 cl_to 
#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
LIMIT 100

SQL

Checking query status...