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
    UNION
  
  UNION SELECT 'Manual_Title_1' AS title
  UNION SELECT 'Manual_Title_2' AS title
)

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, 
  GROUP_CONCAT(page_title ORDER BY page_title ASC SEPARATOR '\n') AS all_page_titles,
  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)
  AND page_title NOT LIKE "Արցախյան_պատերազմում_զոհված_ազատամարտիկների_ցանկ%"
GROUP BY extracted_text
HAVING C > 2 AND C < 100
ORDER BY C DESC
SQL

Checking query status...
