List of my bounties including the bounty comment


Please login or register to vote for this query.

(click on this box to dismiss)

Health Meta

Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

SELECT pn.PostId AS [Post Link], pn.Body, *
FROM PostHistory ph 
JOIN PostNotices pn ON ph.Comment=pn.Id
WHERE ph.PostHistoryTypeId=33
  AND pn.OwnerUserId=##userid##
--33 = Post notice added - comment contains foreign key to PostNotices

SELECT TOP 100 * FROM Votes WHERE VoteTypeId = 9 AND BountyAmount > 0
SELECT TOP 100 * FROM PostHistoryTypes 

-- Vote Type 9 BountyClose

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results