0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited nov 21 14

created nov 21 14 Jon "not doe" Ericson