Untitled query #79924

SQL

WITH DisambigPages AS
(
  SELECT DISTINCT REPLACE(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
)

SELECT 
  CASE 
    WHEN LOCATE('(', page_title) > 0 AND page_title LIKE "%(%)"
    THEN SUBSTRING(page_title, 1, LOCATE('(', page_title) - 2) 
    ELSE page_title 
  END AS extracted_text, 
  COUNT(*) AS C
FROM page
WHERE page_is_redirect = 0 
  AND page_namespace = 0 
  AND SUBSTRING(page_title, 1, LOCATE('(', page_title) - 2) NOT IN (SELECT title FROM DisambigPages)
  AND page_title NOT IN (SELECT title FROM DisambigPages)
GROUP BY extracted_text
HAVING C > 1
ORDER BY C DESC
LIMIT 100;
SQL

Checking query status...
