/* I also would like to check for GA reassessment without a GA review */

/* Ah, will I have to have an OR to account for all the redirects to the template? I'll have to check. */

/* This is a slow query when just collecting pages with the template, probably because of all the columns it's collecting from each row. */

/* I got 30,000+ results from this originally, but that was when it wasn't restricted to the article namespace

I will want to look at the results not in article namespace */

SELECT page_title

FROM page

INNER JOIN templatelinks ON tl_from = page_id

WHERE page_namespace = 0

  AND tl_namespace = 10

  AND tl_title = "Good_article"

  AND NOT EXISTS (

    SELECT 1

    FROM (

      SELECT

      page_title as page2_title,

      page_namespace as page2_namespace

      FROM page

    ) AS page2

    WHERE page2_namespace = 1

      AND page2_title = CONCAT(page_title, "/GA1")

  )