1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for cartographers, geographers and GIS professionals

SELECT TOP 10
  p.Title,
  vt.Name AS VoteType
FROM Posts p
JOIN Votes v ON p.Id = v.PostID
JOIN VoteTypes vt ON vt.Id = v.VoteTypeID
WHERE p.ClosedDate IS NOT NULL
AND vt.Name NOT IN ('UpMod','Favorite','DownMod','ModeratorReview')

view current version

edited may 18 17

created may 18 17 Evil Genius