@rene Can we please have a (cross-site if possible) query for questions that have been affected by this bug? Basically, questions that meet the criteria for RemoveDeadQuestions or RemoveAbandonedClosed but are not being deleted by these scripts as a result of having been migrated from another site.

@SonictheStay-HomeHedgehog something like this: data.stackexchange.com/musicfans/query/1239108

@rene Doesn't quite work. Some of the questions have positively-scored or accepted answers.

I'm looking for questions that would qualify for automatic deletion under those two specific criteria, but have been migrated from another site.

yeah, I didn't add the other restrictions, yet. Wanted to verify this is what you had in mind

@rene Yeah, it seems to be what I'm looking for. It's worth noting that links to Ask Ubuntu Meta don't work.

Most of the query results seem to be questions closed as duplicates, which are exempt from RemoveAbandonedClosed (but not RemoveDeadQuestions); those that aren't eligible for the latter are simply noise in the query results.

Okay, I'll add to exclude dupe closed and those with postive or accepted answers

@SonictheStay-HomeHedgehog now done: data.stackexchange.com/musicfans/query/1239108

@rene Dupe closed ones don't need to be excluded in all cases. They can be included if the question has a negative score and no answers.

pff

How about splitting it into two queries: one for questions that would qualify for RemoveAbandonedClosed but aren't being deleted because they were migrated, and the same for RemoveDeadQuestions.

(If combining them is too difficult.)

That way, you don't have to deal with including duplicate questions in only some cases.

Thanks for the query, though! I'll leave a comment on the bug report with it.

@rene Your query brought up some interesting results. In particular, it's not just newer questions closed after the feature change that were affected, but also much older questions closed before the whole migration rejection feature rolled out. That widens the bug's scope. It would be very nice if you added an extra column indicating the closure date, so these older cases can be distinguished from newer cases.

@SonictheStay-HomeHedgehog yeah, I had to tweak a bit already to make it run quick enough. I'll revisit tomorrow

@SonictheStay-HomeHedgehog closeddate is now added

Thanks!