get count of anonymous feedback of a post

Please login or register to vote for this query.

(click on this box to dismiss)

This SQL query gets the cumulative anonymous and low-rep post votes for a specific post. 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 t.Name AS 'Feedback Type', COUNT(*) AS 'Feedback Count'
FROM PostFeedback f
INNER JOIN VoteTypes t
  ON f.VoteTypeId=t.Id
WHERE f.PostId = ##postId##
GROUP BY f.PostId, t.Name
ORDER BY t.Name DESC

edited jul 19 22

created jul 18 22

dan1st

Enter Parameters

Options: Text-only results Include execution plan

Switch to meta site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached