ที่ถูกย้ายมาจากไซต์อื่นและอาจตอบได้เอง คำถามที่ถูกย้ายและไม่มีเจ้าของ และมีคำตอบจากผู้ใช้ที่ลงทะเบียนชื่อเดียวกัน ไม่จำเป็นต้องใช้ตารางทั้งหมด
s that were migrated from another site and may be self-answered. Questions that were migrated and have no owner,
and that have an answer from a registered user with the same name.It is not neccessary to use all the tables.
 PostLinks:  Id [ number]  CreationDate [ time]  PostId [ number]  RelatedPostId [ number]  LinkTypeId [ number] 
SELECT q.Id AS "post_link", q.CreationDate AS "date", q.OwnerDisplayName AS "user_name", a.OwnerUserId AS "user_link", ph.Comment AS "comment" FROM Posts AS q INNER JOIN PostHistory AS ph ON ph.PostId = q.Id INNER JOIN Posts AS a ON a.ParentId = q.Id AND a.OwnerDisplayName = q.OwnerDisplayName WHERE ph.PostHistoryTypeId = 17 AND q.PostTypeId = 1 AND q.OwnerUserId IS NULL AND NOT a.OwnerUserId IS NULL ORDER BY q.Id DESC LIMIT 1000