คำถามถูกปิด แก้ไขโดยผู้ใช้ใดๆ และเปิดใหม่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Questions Closed, Edited by Any User and Reopened.It is not neccessary to use all the tables.
 Tags:  Id [ number]  TagName [ text]  Count [ number]  ExcerptPostId [ number]  WikiPostId [ number] 
SELECT i.PostId AS "post_link" FROM PostHistory AS i INNER JOIN PostHistory AS c ON i.PostId = c.PostId AND i.PostHistoryTypeId = 1 AND c.PostHistoryTypeId = 10 INNER JOIN PostHistory AS e ON c.PostId = e.PostId AND e.PostHistoryTypeId = 5 AND c.CreationDate < e.CreationDate AND i.UserId = e.UserId INNER JOIN PostHistory AS r ON c.PostId = r.PostId AND r.PostHistoryTypeId = 11 AND r.CreationDate > e.CreationDate WHERE i.CreationDate >= DATEADD(DAY, -15, GETDATE()) GROUP BY i.PostId