มีค่าหัวและ 0 คำตอบ ไม่จำเป็นต้องใช้ทุกตาราง
s with bounty and 0 answers.It is not neccessary to use all the tables.
 PostNoticeTypes:  Id [ number]  ClassId [ number]  Name [ text]  Body [ text]  IsHidden [ boolean]  Predefined [ boolean]  PostNoticeDurationId [ number] 
SELECT Posts.Id AS "post_link", Votes.BountyAmount, Votes.CreationDate AS BountyStart FROM Posts INNER JOIN Votes ON Posts.Id = Votes.PostId INNER JOIN PostTags ON Posts.Id = PostTags.PostId INNER JOIN Tags ON PostTags.TagId = Tags.Id WHERE Votes.VoteTypeId = 8 AND Tags.TagName = '##tag##' AND Posts.AnswerCount = 0 AND Votes.CreationDate > DATEADD(day, -7, GETDATE()) ORDER BY Votes.CreationDate DESC