Untitled query #84036

SQL

WITH cte_biog AS (
  SELECT page_title FROM page
  INNER JOIN categorylinks AS cl
  ON cl.cl_from = page.page_id
  WHERE cl.cl_to IN (
    'FA-Class_biography_articles',
    'FL-Class_biography_articles',
    'FM-Class_biography_articles',
    'GA-Class_biography_articles',
    'B-Class_biography_articles',
    'C-Class_biography_articles',
    'Start-Class_biography_articles'
    'Stub-Class_biography_articles',
    'List-Class_biography_articles',
    'Disambig-Class_biography_articles',
    'Redirect-Class_biography_articles',
    'Unassessed_biography_articles')
), cte_priority (title, priority) AS (
  SELECT
	page.page_title,
    REPLACE(cl.cl_to,'-priority_mathematics_articles','')
  FROM page
  INNER JOIN categorylinks AS cl ON cl.cl_from = page.page_id 
  WHERE
  	cl.cl_to IN (
	  'Top-priority_mathematics_articles',
	  'High-priority_mathematics_articles',
	  'Mid-priority_mathematics_articles',
	  'Low-priority_mathematics_articles',
	  'NA-priority_mathematics_articles',
	  'Unknown-priority_mathematics_articles')
    AND page.page_title NOT IN cte_biog
)

SELECT * FROM cte_priority LIMIT 10
SQL

Checking query status...
