s.ไม่จำเป็นที่จะต้องใช้ทุกตาราง
s.It is not neccessary to use all the tables.
 ReviewTaskTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT CASE WHEN (P.PostTypeId = 1) THEN P.Title ELSE (SELECT Title FROM Posts WHERE Posts.Id = P.ParentId LIMIT 1) END AS "question_title", PHT.Name + CASE WHEN P.PostTypeId = 1 THEN ' of question' ELSE ' of answer' END AS "edit_type", PH.CreationDate AS "edit_date", 'site://questions/' + CAST(P.Id AS TEXT(30)) + '|Post #' + CAST(P.Id AS TEXT(30)) AS "link" FROM PostHistory AS PH, Posts AS P, PostHistoryTypes AS PHT WHERE (P.Id = PH.PostId AND PH.PostHistoryTypeId = PHT.Id) AND PH.UserId = '##UserId##' AND P.OwnerUserId = '##UserId##' AND P.PostTypeId = 1 AND PHT.Name LIKE 'Post%' ORDER BY PHT.Name, PH.CreationDate DESC