Identification Request Cleanup: Phase 3 (Final) -- Delete & Lock

Question

Phase 3: Delete and Lock

Continuing with our our cleanup of "identification request", as detailed in this proposal.

I would ask the CMs to do the following as the final part of our three-phase process to remove identification questions from our community.

• Please delete all "identification-requests" without a question score of 4 or higher AND at least an answer with a score of 3 or higher.
• Please apply a historical lock on ALL questions tagged with identification-request (and tag synonyms, as needed).
  • If it's not any extra work, please give a brief synopsis of the number of questions that were deleted and the number that will remain locked.

As always, please let us know if you have questions or comments on the details or procedures made in this post.

Farewell identification-request.

Answer 1

This has been completed. 1637 were deleted, and 396 locked. As with closing before, the questions will appear as deleted or locked by me.

Answer 2

For verification and archival purpose, I have compiled the list of questions to be deleted with post ID, title and score, based on the conditions above.

The list above is generated from this query, which will stop working next week, when Data Explorer is refreshed with a new dump.

select p.id as [Post Link], p.title, p.answercount, p.score, q.score
from posts p left join (
  select a.parentid, max(a.score) as score
  from posts a
  where a.posttypeid = 2
  group by a.parentid
) q on p.id = q.parentid
where p.tags like '%<identification-request>%'
and (p.score < 4 or q.score < 3 or q.score is null)

After fixing a derp in my query, the number of questions to be removed (1638) now more or less matches the number from JNat's post (1637), with the exception of one post which has been removed earlier by Oded. The one exception aside, I have confirmed that both delete lists contain the same questions.

The number of remaining questions (396) matches the number currently on the site, so there seems to be no hiccup in the process. For extra precaution, I have compared and confirmed that the list of questions from Data Explorer matches the list from JNat's post.

Note that the remaining questions cannot be accessed via identification-request when they are locked. Hopefully, the tag is still recorded in the question, so that the search query still works.