ปิดแล้วให้คะแนน 1 ไม่มีคำตอบหรือแสดงความคิดเห็น ไม่จำเป็นต้องใช้ทุกตาราง
Closed, score 1, no answers or comments.It is not neccessary to use all the tables.
 ReviewRejectionReasons:  Id [ number]  Name [ text]  Description [ text]  PostTypeId [ number] 
SELECT CreationDate, Id AS "post_link" FROM Posts AS p WHERE NOT ClosedDate IS NULL AND Score = 1 AND CommentCount = 0 AND AnswerCount = 0 AND NOT EXISTS(SELECT l.Id FROM PostLinks AS l WHERE l.PostId = p.Id OR l.RelatedPostId = p.Id) ORDER BY CreationDate