Untitled query #80060

SQL

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 p1.page_namespace = 0
  AND (pl_title in
         (SELECT p2.page_title
          FROM page AS p2
          JOIN categorylinks ON p2.page_id = cl_from
          WHERE p2.page_namespace = 0 AND cl_to = "Բազմիմաստության_փարատման_էջեր")
       OR pl_title in
         (SELECT p3.page_title
          FROM redirect
          JOIN page AS p3 ON rd_from = p3.page_id
          WHERE p3.page_namespace = 0 AND rd_title IN
              (SELECT p4.page_title
               FROM page AS p4
               JOIN categorylinks ON p4.page_id = cl_from
               WHERE p4.page_namespace = 0 AND cl_to = "Բազմիմաստության_փարատման_էջեր")))
GROUP BY pl_title
HAVING c > 10
ORDER BY C DESC
SQL

Checking query status...
