Currently, there's no reliable way to remap abuse log entries to MW log entries because the abuse_filter_log table does not store any reference to the associated MW log action.
For edit actions, remapping can be done via the afl_rev_id column, but since AbuseFilter supports non-edit actions like delete and createaccount, there should be a way to reverse-search these actions from abuse logs.
As a solution, I'd like to propose adding an afl_rc_id column, which corresponds to rc_id in the recentchanges table.
Once we have this, it will be possible to reverse-search any information this table holds, for example the oldid of an edit, logid of a log action, and even block IDs stored in rc_params.
See also:
- T335649: Make AbuseFilter action reverting easier
- At the moment it's almost impossible to filter out abuse log entries whose associated actions have already been reverted, because we don't know the associated MW log IDs.
- T415584#11563795