คำถามที่ทำเครื่องหมายว่าซ้ำกันโดยไม่มีการแก้ไข (WIP Not Complete) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Questions marked as duplicate without solved(WIP Not Complete).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 * FROM POSTS PS WHERE PS.ID IN ( SELECT SUBSTRING(PH.Text,24,CHARINDEX(PH.Text, ']')) FROM Posts P INNER JOIN PostHistory PH ON P.Id=PH.PostId AND PH.PostHistoryTypeId =10 AND PH.Comment=1 WHERE P.ClosedDate IS NOT NULL ) */ SELECT SUBSTRING(PH.Text, STR_POSITION(ph.Text, ''), STR_POSITION(PH.Text, '')) FROM Posts AS P INNER JOIN PostHistory AS PH ON P.Id = PH.PostId AND PH.PostHistoryTypeId = 10 AND PH.Comment = 1 WHERE NOT P.ClosedDate IS NULL