s เรียงลำดับโดยการประทับเวลาปิด ไม่จำเป็นต้องใช้ตารางทั้งหมด
s, ordered by closure timestamp.It is not neccessary to use all the tables.
 Votes:  Id [ number]  PostId [ number]  VoteTypeId [ number]  UserId [ number]  CreationDate [ time]  BountyAmount [ number] 
SELECT PostHistory.PostId AS "post_link", PostHistory.CreationDate AS PostClosureDate, PostHistory.UserId AS "user_link", PostHistory.Comment AS PostClosureComment, CAST(SUBSTRING(PostHistory.Text, STR_POSITION(PostHistory.Text, 'Voters') + 15, STR_POSITION(PostHistory.Text, 'Display') - STR_POSITION(PostHistory.Text, 'Voters') - 17) AS INT) AS "user_link", PostHistory.Text AS PostClosureText FROM PostHistory WHERE PostHistoryTypeId = 10 ORDER BY PostHistory.CreationDate DESC LIMIT 200