SQL
x
SELECT log_timestamp, actor_name, log_title, comment_text FROM logging_userindex
JOIN actor ON log_actor = actor_id
JOIN comment ON log_comment_id = comment_id
WHERE log_type = "rights"
AND log_action = "rights"
AND log_params LIKE "%newgroups%oversight%"
AND log_params NOT LIKE "%oldgroups%oversight%newgroups%"
AND log_title NOT LIKE CONCAT(REPLACE(actor_name, " ", "_"), "@", "%")
AND log_title != REPLACE(actor_name, " ", "_")
ORDER BY log_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.