โดย non-noobs สำหรับแท็ก ไม่จำเป็นต้องใช้ตารางทั้งหมด
s by non-noobs for a tag.It is not neccessary to use all the tables.
 Votes:  Id [ number]  PostId [ number]  VoteTypeId [ number]  UserId [ number]  CreationDate [ time]  BountyAmount [ number] 
SELECT Posts.Id AS "post_link", Posts.Tags AS "tags", Posts.Score, Posts.ViewCount, Users.Reputation, Posts.CreationDate, Users.LastAccessDate FROM Posts INNER JOIN PostTags ON Posts.Id = PostTags.PostId INNER JOIN Tags ON PostTags.TagId = Tags.Id INNER JOIN Users ON Posts.OwnerUserId = Users.Id WHERE Tags.TagName = @TagName AND Posts.AnswerCount = 0 AND Posts.PostTypeId = 1 AND Posts.CommunityOwnedDate IS NULL AND Posts.ClosedDate IS NULL AND Users.Reputation > @minRep ORDER BY Posts.CreationDate DESC