ดึงโพสต์ของแท็กที่ผู้ใช้ระบุและด้วยคำหลักในเนื้อหาและชื่อเรื่อง ไม่จำเป็นต้องใช้ตารางทั้งหมด
Retrieve posts of a user-specified tag and with keywords in body and title.It is not neccessary to use all the tables.
 PostsWithDeleted:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
SELECT Posts.Id AS "post_link", Posts.Title, ViewCount FROM Tags JOIN PostTags ON PostTags.TagId = Tags.Id JOIN Posts ON Posts.Id = PostTags.PostId WHERE Tags.TagName = '##TagName##' AND (LENGTH(Posts.Body) <= 1000) AND ((Posts.Body LIKE '%compare(%') OR (Posts.Body LIKE '%compareTo%') OR (Posts.Body LIKE '%<code>%')) AND (Posts.Body LIKE '%total order%' OR Posts.Body LIKE '%transitive%' OR Posts.Body LIKE '%symmetric%' OR Posts.Body LIKE '%reflexive%') GROUP BY Posts.Id, Posts.Title, Posts.ViewCount