ที่คุณตอบ (และไม่ว่าจะมีการแก้ไขหลังจากปิดหรือไม่) ไม่จำเป็นต้องใช้ตารางทั้งหมด
s which you ANSWERED (and whether they were edited after close).It is not neccessary to use all the tables.
 ReviewTasks:  Id [ number]  ReviewTaskTypeId [ number]  CreationDate [ time]  DeletionDate [ time]  ReviewTaskStateId [ number]  PostId [ number]  SuggestedEditId [ number]  CompletedByReviewTaskId [ number] 
SELECT Id AS "post_link", Score, ViewCount AS "views", OwnerUserId AS "asker", CreationDate AS "asked", ClosedDate AS "closed", LastEditDate AS "edited", CASE WHEN LastEditDate > ClosedDate THEN 'yes' ELSE 'no' END AS "edited_after_close" FROM Posts WHERE NOT ClosedDate IS NULL AND Id IN (SELECT DISTINCT ParentId FROM Posts WHERE OwnerUserId = '##UserID##') ORDER BY CreationDate DESC