Uncategorized GA templates

Fork of Templates with a specific string in the title by Retro

This query is marked as a draft This query has been published by Retro.

SQL

# Previous:
# * "Danger"
# * "icon"
SET @in_string = "GA";

USE enwiki_p;
SELECT *
FROM page
WHERE
  page_namespace = 10
  AND page_title LIKE CONCAT("%", @in_string, "%")
  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"
      )
  )
    /* 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...