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 ("African-American_television_personalities",
                    "African-American_businesspeople",
                    "American_fashion_designers",
            		"American_business_writers",
            		"Businesspeople_from_New_York_City",
            		"African-American_billionaires",
            		"African-American_fashion_designers",
                    "African-American_investors",
                    "American_fashion_businesspeople"
                   ) #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...
