แท็กที่มีข้อความที่ตัดตอนมา แต่ไม่มีวิกิ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Tags with excerpts but no wikis.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 t.TagName, t.Count, ep.Body AS ExcerptBody, wp.Body AS WikiBody FROM Tags AS t LEFT JOIN Posts AS ep ON t.ExcerptPostId = ep.Id LEFT JOIN Posts AS wp ON t.WikiPostId = wp.Id ORDER BY t.Count DESC