ยอมรับแต่ปิดด้วยคะแนน ไม่จำเป็นต้องใช้ทุกตาราง
s accepted but closed by score.It is not neccessary to use all the tables.
 Badges:  Id [ number]  UserId [ number]  Name [ text]  Date [ time]  Class [ number]  TagBased [ boolean] 
SELECT p.Id, 'http://movies.stackexchange.com/questions/' + CAST(p.Id AS TEXT(20)) AS Link, p.Title, p.Score FROM Posts AS p LEFT OUTER JOIN (SELECT PostId, ROW_NUMBER() OVER (PARTITION BY PostId ORDER BY CreationDate DESC) AS rn FROM PostHistory AS ph WHERE PostHistoryTypeId = 10 AND Comment = '101') AS cdph ON p.Id = cdph.PostId AND cdph.rn = 1 WHERE p.PostTypeId = 1 AND p.Tags LIKE '%identify%' AND NOT p.ClosedDate IS NULL AND NOT p.AcceptedAnswerId IS NULL AND cdph.PostId IS NULL ORDER BY Score DESC