Get anonymous feedback of all answers of a question

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

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

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

Enter Parameters

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