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

SQL

AخA
 
SELECT
  user_name,
  Max(rev_timestamp) as "last edit"
FROM
  user
  JOIN revision_userindex ON user_id = rev_user
  JOIN page ON page_id = rev_page
WHERE
  (
    page_title LIKE "Bots/Requests_for_approval%"
    OR page_title = "Bot Approvals Group"
    OR page_title = "Bot policy"
    OR page_title = "Bots"
    OR page_title = "Bots/Noticeboard"
  )
  AND (
    user_name = "Anomie"
    OR user_name = "BU Rob13"
    OR user_name = "Cyberpower678"
    OR user_name = "Headbomb"
    OR user_name = "HighInBC"
    OR user_name = "MBisanz"
    OR user_name = "MusikAnimal"
    OR user_name = "Slakr"
    OR user_name = "SQL"
    OR user_name = "The Earwig"
    OR user_name = "Xaosflux"
    OR user_name = "Semi-active Members"
    OR user_name = "Addshore"
    OR user_name = "Hellknowz"
    OR user_name = "Jarry1250"
    OR user_name = "Kingpin13"
    OR user_name = "MaxSem"
    OR user_name = "Maxim"
    OR user_name = "Inactive Members"
    OR user_name = "Aaron Schulz"
    OR user_name = "Brandon"
    OR user_name = "Carnildo"
    OR user_name = "Chris G"
    OR user_name = "Cobi"
    OR user_name = "Coren"
    OR user_name = "Daniel"
    OR user_name = "Gimmetrow"
    OR user_name = "Jake Wartenberg"
    OR user_name = "JamesR"
    OR user_name = "Josh Parris"
    OR user_name = "Madman"
    OR user_name = "Mets501"
    OR user_name = "Mr.Z-man"
    OR user_name = "OverlordQ"
    OR user_name = "Quadell"
    OR user_name = "Reedy"
    OR user_name = "Snowolf"
    OR user_name = "ST47"
    OR user_name = "Tawker"
    OR user_name = "Tim1357"
    OR user_name = "Tinucherian"
    OR user_name = "Werdna"
  )
  AND (
    page_namespace = 4
    OR page_namespace = 5
  )
GROUP BY
  user_name
ORDER BY
  max(rev_timestamp) DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...