Q&A for professional and enthusiast programmers
-- Check the presence of BountyAmount and UserId data for BountyXX events -- See the following feature requests for the details: http://meta.stackoverflow.com/q/115855/ and http://meta.stackoverflow.com/q/110182/ select PostId [Post Link], UserId, CreationDate, VT.Name, BountyAmount from VoteTypes VT join ( select top 10 * from Votes where VoteTypeId = 9 union all select top 10 * from Votes where VoteTypeId = 8 ) T on T.VoteTypeId=VT.id