Summary
Revisions in deleted pages are not surfaced in Special:AbuseReview, because the feature only selects rows from the revision table and does not consider the archive table
Technical details
- The AbuseReviewPager only selects rows from the revision table. We will need to also select rows from the archive table as part of the queries, as deleted pages are not necessarily suppressed (and so may still need handling)
- This will need to involve us making the query combine rows from multiple tables and then page on them
- We can use the Special:CheckUser pagers as an example of this (as they combine rows from multiple tables and then page on them)
Acceptance criteria
- Rows in the archive table with the relevant review abuse tags are shown in Special:AbuseReview