Untitled query #84045

SQL

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
SQL

Checking query status...
