GA/FA (candidates) filters

SQL

SELECT
  * #Faster than just selecting the page title and id, but only those are needed
FROM
  page pg1
WHERE
  pg1.page_namespace = 0
  AND pg1.page_title IN ( #Where page is linked from a specified other page
    SELECT
      pl_title
    FROM
      pagelinks
    WHERE
      pl_from = 18679439 #Other page's page ID (faster to check manually than to need to query)
      AND pl_namespace = 0 #Only if the target is an 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 ("Good_article", "Featured_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...
