Anon feedback explorer for user


Please login or register to vote for this query.

(click on this box to dismiss)

Based on get back all anon-feedback for the posts of a given user

Stack Overflow

Q&A for professional and enthusiast 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)
  P.OwnerUserid = ##UserId##
  and PF.IsAnonymous = 1
group by
  PF.PostID, P.PostTypeId, PF.VoteTypeID, P.viewcount, PP.viewcount
order by
  votecount DESC,
  viewcount DESC

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results