BAG Activity - with status

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

SELECT
  user_name,
  Max(rev_timestamp) as "last edit",
  case
    WHEN user_name = "SQL" THEN "active"
    WHEN user_name = "Anomie" THEN "active"
    WHEN user_name = "BU Rob13" THEN "active"
    WHEN user_name = "Cyberpower678" THEN "active"
    WHEN user_name = "Headbomb" THEN "active"
    WHEN user_name = "HighInBC" THEN "active"
    WHEN user_name = "MBisanz" THEN "active"
    WHEN user_name = "MusikAnimal" THEN "active"
    WHEN user_name = "Slakr" THEN "active"
    WHEN user_name = "SQL" THEN "active"
    WHEN user_name = "The Earwig" THEN "active"
    WHEN user_name = "Xaosflux" THEN "active"
    WHEN user_name = "Addshore" THEN "semi-active"
    WHEN user_name = "Hellknowz" THEN "semi-active"
    WHEN user_name = "Jarry1250" THEN "semi-active"
    WHEN user_name = "Kingpin13" THEN "semi-active"
    WHEN user_name = "MaxSem" THEN "semi-active"
    WHEN user_name = "Maxim" THEN "semi-active"
    WHEN user_name = "Aaron Schulz"THEN "inactive"
    WHEN user_name = "Brandon" THEN "inactive"
    WHEN user_name = "Carnildo" THEN "inactive"
    WHEN user_name = "Chris G" THEN "inactive"
    WHEN user_name = "Cobi" THEN "inactive"
    WHEN user_name = "Coren" THEN "inactive"
    WHEN user_name = "Daniel" THEN "inactive"
    WHEN user_name = "Gimmetrow" THEN "inactive"
    WHEN user_name = "Jake Wartenberg" THEN "inactive"
    WHEN user_name = "JamesR" THEN "inactive"
    WHEN user_name = "Josh Parris" THEN "inactive"
    WHEN user_name = "Madman" THEN "inactive"
    WHEN user_name = "Mets501" THEN "inactive"
    WHEN user_name = "Mr.Z-man" THEN "inactive"
    WHEN user_name = "OverlordQ" THEN "inactive"
    WHEN user_name = "Quadell" THEN "inactive"
    WHEN user_name = "Reedy" THEN "inactive"
    WHEN user_name = "Snowolf" THEN "inactive"
    WHEN user_name = "ST47" THEN "inactive"
    WHEN user_name = "Tawker" THEN "inactive"
    WHEN user_name = "Tim1357" THEN "inactive"
    WHEN user_name = "Tinucherian" THEN "inactive"
    WHEN user_name = "Werdna" THEN "inactive"
  END as status
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 = "Addshore"
    OR user_name = "Hellknowz"
    OR user_name = "Jarry1250"
    OR user_name = "Kingpin13"
    OR user_name = "MaxSem"
    OR user_name = "Maxim"
    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.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
