SQL
x
SELECT
main.page_title AS title_en
FROM page AS talk
# focus to all possible quality for an article in main namespace
# this should also implicitly include article's priority
INNER JOIN categorylinks AS cl_qual ON
cl_qual.cl_from = talk.page_id
AND cl_qual.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')
# join to get the main article's ID
INNER JOIN page AS main ON
main.page_namespace = 0
AND main.page_title = talk.page_title
LIMIT 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.