Mzajac's admin actions since 2010

Mzajac's logged admin actions since 2010, excluding deletions and protections made automatically as part of a page move.

In reply to Ymblanter's comment at [[WP:ARC]] on 9 January 2024 circa [[Special:Permalink/1194510961]].

SQL

SELECT log_id, log_type, log_action, log_timestamp, log_namespace, log_title, log_params, log_deleted, log_page, comment_text
FROM logging_userindex
JOIN actor_logging ON actor_id = log_actor
LEFT JOIN comment_logging ON comment_id = log_comment_id
WHERE actor_name = 'EggRoll97'
  AND log_timestamp >= '2010'
  AND log_type NOT IN ('upload', 'move', 'create', 'thanks', 'spamblacklist', 'review', 'patrol', 'pagetriage-curation')
  AND NOT (log_type = 'delete' AND log_action = 'delete_redir')
  AND NOT (log_type = 'protect' AND log_action = 'move_prot')
  AND comment_text != '[[WP:CSD#G6|G6]]: Deleted to make way for move'
ORDER BY log_timestamp ASC;

SQL

Checking query status...