ปิดในแท็ก ค้นหาคำแนะนำที่หลอกลวงเก่าซึ่งการตั้งค่าสถานะหมดเวลา ไม่จำเป็นต้องใช้ตารางทั้งหมด
closure in a tag. Locate old dupe suggestions where the flag has timed outIt is not neccessary to use all the tables.
 Posts:  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 p.Id AS "post_link", p.CreationDate FROM Comments AS c JOIN Posts AS p ON c.PostId = p.Id JOIN PostTags AS pt ON pt.PostId = p.Id JOIN Tags AS t ON t.Id = pt.TagId WHERE c.Text LIKE '%possible duplicate%' AND p.ClosedDate IS NULL AND p.PostTypeId = 1 AND t.TagName = @Tag ORDER BY p.Id