Untitled query #84036

SQL

SELECT
	main.page_title AS title_en,
	(
      SELECT COUNT(pl.pl_from)
      FROM pagelinks AS pl
      WHERE pl.pl_target_id = lt.lt_id
    ) 

# berangkat dari halaman pembicaraan
FROM page AS talk
# cari halaman yang punya kategori prioritas matematika (ini ada di WHERE)
LEFT JOIN categorylinks AS cl ON cl.cl_from = talk.page_id
# dapatkan data linktarget halaman artikel (ruang nama utama) dari nama halaman pembicaraan
LEFT JOIN linktarget AS lt ON lt.lt_title = talk.page_title AND lt.lt_namespace = 0

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 10;
SQL

Checking query status...
