Enwiki 2024 administrator election voter guides

Fork of Enwiki 2024 administrator election voter guides by Novem Linguae

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

SQL

SELECT CONCAT('User:', REPLACE(page_title, '_', ' ')) AS namespace_and_title
FROM page
WHERE page_id > 78000000
AND page_title LIKE '%/%'
AND page_title NOT LIKE '%/%/%'
AND page_title NOT RLIKE '.*[Bb][Oo][Tt].*\/.*'
AND (
  page_title RLIKE '.*\/.*[Ee][Ll][Ee][Cc][Tt][Ii][Oo][Nn].*' OR
  page_title RLIKE '.*\/.*[Vv][Oo][Tt][Ee][Rr].*' OR
  page_title RLIKE '.*\/.*[Ee][Ff][Aa].*'
)
AND page_namespace = 2 # userspace
AND page_latest > 1249959326 # has an edit after Oct 7, 2024
AND page_is_redirect = 0

SQL

Checking query status...