Question Reopens by Vote Counts

1

Please login or register to vote for this query.

(click on this box to dismiss)

GIS

Q&A for cartographers, geographers and GIS professionals

SELECT TOP 10
  p.Title,
  p.ClosedDate,
  v.CreationDate AS CloseVoteDate,
  vt.Name AS VoteType,
  u.DisplayName AS VoteUser,
  v.*
FROM Votes v 
JOIN Posts p ON p.Id = v.PostID
JOIN VoteTypes vt ON vt.Id = v.VoteTypeID
LEFT JOIN Users u ON u.Id = v.UserId
WHERE p.ClosedDate IS NOT NULL
AND vt.Name = 'Close'

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results