Q&A for system and network administrators
select Name, MarkdownMini, count(*) Flags from PendingFlags left outer join CloseAsOffTopicReasonTypes ot on ot.Id = CloseAsOffTopicReasonTypeId join CloseReasonTypes cr on cr.Id = CloseReasonTypeId group by Name, MarkdownMini order by count(*) desc