กระทู้ล่าสุดโดยผู้ดูแลคณิตศาสตร์ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Most recent posts by Mathematics moderators.It is not neccessary to use all the tables.
 TagSynonyms:  Id [ number]  SourceTagName [ text]  TargetTagName [ text]  CreationDate [ time]  OwnerUserId [ number]  AutoRenameCount [ number]  LastAutoRename [ time]  Score [ number]  ApprovedByUserId [ number]  ApprovalDate [ time] 
WITH recent_cte AS (SELECT OwnerUserId AS UserId, MAX(Id) AS MaxId FROM Posts AS p WHERE p.OwnerUserId IN (622, 9754, 12952, 13854, 21674, 23350, 44121, 59234, 83702, 85306) GROUP BY p.OwnerUserId) SELECT UserId AS "user_link", MaxId AS "post_link", p.CreationDate, p.Score FROM recent_cte INNER JOIN Posts AS p ON MaxId = p.Id ORDER BY p.CreationDate DESC