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.