Pending close flags by close reason

0

Please login or register to vote for this query.

(click on this box to dismiss)

List the number of questions flagged (/voted) according to each close reason. Will double-count questions if two different reasons are selected.

Stack Overflow

Q&A for programmers

select cr.Name, count(distinct PostId)
from PendingFlags f
join CloseReasonTypes cr on cr.Id=f.CloseReasonTypeId
where FlagTypeId in (14,13)
group by cr.Name
order by count(distinct PostId) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results