Tags on review page

0

Please login or register to vote for this query.

(click on this box to dismiss)

http://meta.stackoverflow.com/questions/255131/tags-on-review-page/327538#327538

Stack Overflow

Q&A for professional and enthusiast programmers

select t.tagname, count(*)
from pendingflags pf
inner join posttags pt on pt.postid = pf.id
inner join tags t on pt.tagid = t.id
where flagtypeid = 14 -- close
group by t.tagname
order by count(*) desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results