Per post anon-feedback

0

Please login or register to vote for this query.

(click on this box to dismiss)

Based on the query http://data.stackexchange.com/programmers/query/169976/anon-feedback-explorer looks at one post.

Stack Overflow

Q&A for programmers

select
  PF.PostID as [Post Link],
  case P.PostTypeId
    when 1 then 'Q'
    when 2 then 'A'
    else '?'
  end as "Q/A",
  case PF.VoteTypeID
    when 2 then '+'
    when 3 then '-'
    else '?'
  end as "+/-/?",
  count(1) as votecount,
  coalesce (P.viewCount, PP.viewCount) as viewCount
from
  PostFeedback PF
  left join Posts P on (PF.PostID = P.id)
  left join Posts PP on (PP.id = P.parentid)
where
  PF.PostId = ##PostId:int##
  and PF.IsAnonymous = 1
group by
  PF.PostID, P.PostTypeId, PF.VoteTypeID, P.viewcount, PP.viewcount

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results