กำลังรอคำตอบและมีแท็กที่กำหนด ไม่จำเป็นต้องใช้ตารางทั้งหมด
s awaiting answers and with a given tag.It is not neccessary to use all the tables.
 Tags:  Id [ number]  TagName [ text]  Count [ number]  ExcerptPostId [ number]  WikiPostId [ number] 
SELECT u.Id AS "user_link", u.Reputation AS "reputation", q.LastActivityDate AS "last_active", q.ViewCount AS "views", q.Id AS "post_id", q.Id AS "post_link" FROM Posts AS q JOIN PostTags AS pt ON pt.PostId = q.Id JOIN Tags AS t ON t.Id = pt.TagId JOIN Users AS u ON u.Id = q.OwnerUserId WHERE q.PostTypeId = 1 AND q.AnswerCount = 0 AND q.Score > 0 AND q.ClosedDate IS NULL AND q.LastActivityDate > '20181001' AND t.TagName = 'quantum-field-theory' ORDER BY q.LastActivityDate DESC