Untitled query #80146

SQL

WITH DisambigPages AS
  (SELECT DISTINCT p.page_title AS title
   FROM page AS p
   JOIN categorylinks cl ON p.page_id = cl.cl_from
   WHERE cl.cl_to = 'Բազմիմաստության_փարատման_էջեր' AND p.page_namespace = 0 ),
     DisambigRedirect AS
  (SELECT DISTINCT p.page_title title
   FROM redirect
   JOIN page AS p ON rd_from = p.page_id
   WHERE p.page_namespace = 0
     AND rd_title IN
       (SELECT title
        FROM DisambigPages) ),
     AllDisamig AS
  (SELECT title
   FROM DisambigPages
   UNION SELECT title
   FROM DisambigRedirect)

SELECT mainPage.page_title, count(*) AS C
FROM page AS mainPage
LEFT JOIN categorylinks ON cl_from = mainPage.page_title
JOIN pagelinks ON mainPage.page_id = pl_from
JOIN AllDisamig AS allDisambig ON pl_title = allDisambig.title
WHERE mainPage.page_namespace = 0 AND cl_to != 'Ազգանուններ_այբբենական_կարգով'
GROUP BY mainPage.page_title
ORDER BY C DESC
LIMIT 1000
SQL

Checking query status...
