Untitled query #84036

SQL

SELECT
	talk.page_title AS title_en,
    REPLACE(cl_prio.cl_to,'-priority_mathematics_articles','') AS priority

FROM page AS talk

INNER JOIN page AS main
	ON main.page_title = talk.page_title
   
INNER JOIN categorylinks AS cl_prio
	ON cl_prio.cl_from = talk.page_id 

WHERE main.page_namespace = 0
    AND	main.page_is_redirect = 0

    AND cl_prio.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')
    
LIMIT 10
SQL

Checking query status...
