Untitled query #80060

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 = 'Բազմիմաստության_փարատման_էջեր' ),
     DisambigRedirect AS
  (SELECT DISTINCT p.page_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) )
SELECT pl_title,
       count(*) as C
FROM pagelinks
JOIN page AS p1 ON p1.page_id = pl_from
AND p1.page_is_redirect = 0
WHERE pl_title in
    (SELECT p2.page_title
     FROM page AS p2
     JOIN categorylinks ON p2.page_id = cl_from
     WHERE cl_to = "Բազմիմաստության_փարատման_էջեր")
  AND p1.page_namespace = 0
GROUP BY pl_title
HAVING c > 1
ORDER BY C DESC
SQL

Checking query status...
