Untitled query #84036

SQL

SELECT
	main.page_title AS title_en,
    (SELECT 
	    # count unique(?) articles in main namespace, that linked to this article 
     	COUNT(t_pl.pl_from)
     	FROM pagelinks AS t_pl
     	LEFT JOIN linktarget AS t_lt ON t_lt.lt_id = t_pl.pl_target_id AND t_lt.lt_namespace = 0
     	WHERE t_lt.lt_title = main.page_title
    ) AS total_inlink

FROM page AS talk
RIGHT JOIN categorylinks AS cl ON cl.cl_from = talk.page_id
LEFT JOIN page AS main ON main.page_namespace = 0 AND main.page_title = talk.page_title

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 main.page_title IS NOT NULL
    
LIMIT
SQL

Checking query status...
