/* 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. */

SELECT *

FROM page

INNER JOIN templatelinks ON tl_from = page_id

WHERE tl_namespace = 10

  AND tl_title = "Good_article"

  /*AND NOT EXISTS (

    SELECT 1

    FROM (

      SELECT page_title as page2_title

      FROM page

    ) AS page2

    WHERE page_title = page2_title

  )*/

LIMIT 100