Per post anon-feedback


Please login or register to vote for this query.

(click on this box to dismiss)

Based on the query looks at one post.

Stack Overflow

Q&A for programmers

  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
  PostFeedback PF
  left join Posts P on (PF.PostID =
  left join Posts PP on ( = P.parentid)
  PF.PostId = ##PostId:int##
  and PF.IsAnonymous = 1
group by
  PF.PostID, P.PostTypeId, PF.VoteTypeID, P.viewcount, PP.viewcount

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results