https://github.com/WikipediaLibrary/TWLight/pull/1359/files

Testing process:

I have some questions before I think I can work on this ticket:

Attaching the raw sql that is generated from the new query:

I have a patch and the raw SQL query to test, but lack access to stats server, so I'm marking this as stalled.

The partial block functionality worked as expected. See https://test.wikipedia.org/w/index.php?title=Kangaru,_Iran&action=history

No reverts went through during the time that AM was blocked. I'm now setting it to be a partial block on talk pages and letting it sit for awhile to make sure a revert still kicks off on non talk space pages.

I have blocked AutoModeratorTest for 1 day to ensure no reverts go through during this time period.
I have also tested by making "fake" bad reverts on test wiki and have not seen any reverts come through since blocking AutoModeratorTest.

Just consolidating all of the information into one comment:

@Ladsgroup do you know if we need to do anything database related to install ORES extension on idwiki? Also if you have any general insight into the process of installing it that'd be helpful too.
Thanks!

@Ladsgroup thank you, this is very helpful!

This actually seems to no longer be an issue?
I tested the marker on both production and staging and both are working fine for me now.

Hello! I was reaching out to you to get your feedback around the query that is being generated by the newSelectQueryBuilder in this patch and wanted to get your opinion around if you think it would create performance issues.

There are 34 open tasks tagged with both Recent Changes and Watchlist
https://phabricator.wikimedia.org/maniphest/query/4ZnqTqvp8dLR/#R