โพสต์จาก MathOverflow คณิตศาสตร์ที่มีชื่อเดียวกัน ไม่จำเป็นต้องใช้ตารางทั้งหมด
Posts from MathOverflow an Mathematics with the same title.It is not neccessary to use all the tables.
 CloseAsOffTopicReasonTypes:  Id [ number]  IsUniversal [ boolean]  InputTitle [ text]  MarkdownInputGuidance [ text]  MarkdownPostOwnerGuidance [ text]  MarkdownPrivilegedUserGuidance [ text]  MarkdownConcensusDescription [ text]  CreationDate [ time]  CreationModeratorId [ number]  ApprovalDate [ time]  ApprovalModeratorId [ number]  DeactivationDate [ time]  DeactivationModeratorId [ number] 
SELECT a.Id, a.CreationDate AS "MO Date", b.Id AS "post_link", b.CreationDate AS "MSE Date" FROM "stackexchange.mathoverflow".Posts AS a JOIN "stackexchange.math".Posts AS b ON a.Title = b.Title WHERE a.PostTypeId = 1 AND a.ClosedDate IS NULL AND b.ClosedDate IS NULL ORDER BY a.CreationDate