Uncategorized GA templates

SQL

# TODO: make this work lik my section templates query, following redirects and utilizing the main article's categorization.
SET @in_string = "GA";

USE enwiki_p;
SELECT *
FROM page
WHERE
  page_namespace = 10
  AND page_title LIKE CONCAT("%", @in_string, "%")
  AND page_title NOT LIKE "%/doc"
  AND page_title NOT LIKE "%/doc"
  AND NOT EXISTS (
    SELECT 1
    FROM categorylinks
    WHERE cl_from = page_id
      AND cl_to IN (
        "Wikipedia_GA_templates",
        # Subcategories (I wonder if implicit checking is possible)
        "GA_discussion_templates",
        "GA_talk_message_boxes",
        "GA_user_talk_message_templates",
        "Good_content_user_templates",
        # Unrelated to GAs:
        "Gaelic_games_county_navigational_boxes",
        "Gaelic_Athletic_Association_club_navigational_boxes"
      )
  )
  AND page_title NOT LIKE "CF/%" # There's GA-related templates here, but they seem deprecated
  AND page_title NOT LIKE "%-stub%"
  
    /* AND page_title NOT LIKE "Adminstats/%"
    AND page_title NOT LIKE "Did_you_know_nominations/%"
    AND page_title NOT LIKE "Editnotices/%" */
SQL

Checking query status...
