1

Please login or register to vote for this query.

(click on this box to dismiss)

This SQL query gets anonymous and low-rep post votes for all answers of a specific question. It might be useful in combination with the 'anonymous and low rep post feedback' section of the 10k tools. Similar SQL script (but for obtaining all feedback entries of a specific post): https://data.stackexchange.com/stackoverflow/query/1617791/get-anonymous-feedback-of-all-answers-of-a-question?questionId=24198458

Q&A for professional and enthusiast programmers

SELECT
  f.PostId AS PostId,
  t.Name AS FeedbackType,
  COUNT(*) AS 'Number of votes',
  CONCAT('https://stackoverflow.com/a/',f.PostId) AS PostLink,
  AVG(p.Score) AS 'Post Score',
  MIN(u.DisplayName) AS 'Answer Owner'
FROM PostFeedback f
INNER JOIN VoteTypes t
  ON f.VoteTypeId=t.Id
INNER JOIN Posts p
  ON f.PostId = p.Id
INNER JOIN Users u
  ON p.OwnerUserId=u.Id
WHERE p.ParentId = ##questionId##
GROUP BY f.PostId, t.Name
ORDER BY f.PostId

fork query

edited jul 18 22

created jul 18 22 dan1st