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