คำตอบสำหรับคำถามที่ซ้ำกันโดยผู้ใช้ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Answers to Duplicate Questions by User.It is not neccessary to use all the tables.
 PendingFlags:  Id [ number]  FlagTypeId [ number]  PostId [ number]  CreationDate [ time]  CloseReasonTypeId [ number]  CloseAsOffTopicReasonTypeId [ number]  DuplicateOfQuestionId [ number]  BelongsOnBaseHostAddress [ text] 
SELECT 'post_link' = p.Id, a.Score, Answer = CASE WHEN p.AcceptedAnswerId = a.Id THEN 1 ELSE 0 END FROM Posts AS p INNER JOIN Posts AS a ON a.ParentId = p.Id WHERE EXISTS(SELECT 1 FROM PostLinks AS pl WHERE pl.PostId = p.Id AND pl.LinkTypeId = 3)