instruction: You closed these questions, now you can vote for their deletion.
response: WITH DeletableClosed AS (SELECT Id AS "post_link", * FROM Posts WHERE ClosedDate < DATEADD(d, -2, CURRENT_TIMESTAMP())), Raw AS (SELECT PostId, Text FROM PostHistory WHERE PostHistoryTypeId = 10), Raw2 AS (SELECT PostId, JSON_VALUE(Text, '$.Voters0.Id') AS CloserId FROM Raw UNION ALL SELECT PostId, JSON_VALUE(Text, '$.Voters1.Id') AS CloserId FROM Raw UNION ALL SELECT PostId, JSON_VALUE(Text, '$.Voters2.Id') AS CloserId FROM Raw UNION ALL SELECT PostId, JSON_VALUE(Text, '$.Voters3.Id') AS CloserId FROM Raw UNION ALL SELECT PostId, JSON_VALUE(Text, '$.Voters4.Id') AS CloserId FROM Raw) SELECT PostId, CAST(CloserId AS INT) AS CloserId FROM Raw2, Users WHERE Raw2.CloserId = Users.Id AND Users.AccountId = '##SEAccountId:int##'