ข้อเสนอแนะที่ไม่ระบุชื่อสำหรับโพสต์ของคุณ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Anonymous feedback to your posts.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 COUNT(P.Id) AS VoteCount, VT.Name AS VoteType, P.Id AS "post_link", P.Score, P.CreationDate, P.LastActivityDate FROM PostFeedback AS PF JOIN Posts AS P ON P.Id = PF.PostId JOIN PostHistory AS PH ON PF.Id = PH.PostId JOIN VoteTypes AS VT ON PF.VoteTypeId = VT.Id WHERE PF.IsAnonymous = 1 AND PH.Id = 15 GROUP BY P.Id, VT.Id, P.LastActivityDate, P.Score, P.CreationDate, VT.Name ORDER BY VoteCount DESC, VT.Id DESC