Posts by (author) voted to close by (close-voter)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT PostId as [Post Link], phist.Text, phist.Comment
FROM PostHistory phist
JOIN Posts p on phist.PostId = p.Id
WHERE phist.PostHistoryTypeId = 10  -- 10 = Closed
  AND p.OwnerUserId = ##AuthorId##
  AND phist.Text LIKE '%"Id":' + CAST(##CloseVoterId## AS nvarchar) + ',%'

-- Comment values:
-- 101 = duplicate
-- 102 = OT learning materials
-- 103 = unclear what you're asking
-- 104 = too broad
-- 105 = primarily opinion-based

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results