GA/FA and GAN/FAC search

SQL

SELECT
  page_title #Faster than just selecting the page title and id, but only those are needed
FROM
  page pg1
WHERE
  pg1.page_namespace = 0 #Only care about articles
  AND (#AND the page is in specified categories
    (
      pg1.page_id IN ( #Page is in specified categories
        SELECT
          cl_from
        FROM
          categorylinks
        WHERE
          cl_to IN ("Physicians"
                   ) #Categories specified for the article
      )
    ) AND #AND the page is in specified categories
    (
      pg1.page_id IN ( #Page is in specified categories
        SELECT
          cl_from
        FROM
          categorylinks
        WHERE
          cl_to IN ("Living_people") #Categories specified for the article
      )
    )
  )
  AND ( #AND either the page is in specified categories or the talk page is in a different set of specified categories
    (
      pg1.page_id IN ( #Page is in specified categories
        SELECT
          cl_from
        FROM
          categorylinks
        WHERE
          cl_to IN ("Featured_articles",
                   "Good_articles"
                   ) #Categories specified for the article
      )
    )
    OR ( #Talk page is in specified categories
      pg1.page_title IN ( #Match article's title to talk page (corresponding talk page's page ID needed for categorylinks lookup)
        SELECT
          page_title
        FROM
          page pg2
        WHERE
          pg1.page_title = pg2.page_title #Same title
          AND page_namespace = 1 #Page is a talk page
          AND page_id IN ( #Talk page is in categories
            SELECT
              cl_from
            FROM
              categorylinks
            WHERE
              cl_to IN (
                "Wikipedia_featured_article_candidates",
                "Good_article_nominees"
              ) #Categories specified for the talk page
          )
      )
    )
  )
#LIMIT 10
SQL

Checking query status...
