s.ไม่จำเป็นที่จะต้องใช้ทุกตาราง
s.It is not neccessary to use all the tables.
 PostHistoryTypes:  Id [ number]  Name [ text] 
SELECT c.Id AS "comment_link", c.UserId AS "user_link", c.CreationDate, a.Id AS "post_link", c.Text FROM (Posts AS q JOIN Posts AS a ON q.Id = a.ParentId) JOIN Comments AS c ON c.PostId = a.Id WHERE q.OwnerUserId = '##userid##' ORDER BY c.CreationDate DESC LIMIT 100