Any way to see how many questions with certain tag(s) are in the close vote queue?

Question

I just recently started using the filtering options for the close vote review queue. I really like it.

I was searching the data explorer to see if there was currently any methods to see how many questions are in the close vote review queue for a certain tag, but wasn't able to find anything.

I think it would be useful to me and others, if not at least just very interesting to see which tag(s) have the most or least questions in the close vote review queue.

For example, if say a question is tagged with css and jquery , I would like to see how many of these questions are in the close vote queue. So that if I choose to filter by questions containing both those tags, I can then determine how much progress I'm making at clearing those up, and hopefully get them down to 0 if realistically possible. Plus I'd have a better sense of accomplishing something, instead of just always seeing the close vote review queue being increased no matter what we do. On a sidenote: I do think that at least trusted users or even 10kers should get 150 or so close votes per day.

Answer 1

If you just want to use the Data Explorer to get this instead of having this added to the close review queue, then you should be able to use the following query that I just threw together:

select row_number() over (order by p.id),
  p.id AS [Post Link], p.tags
from posts p
inner join votes v
  on p.id = v.postid
inner join posttags pt
  on p.id = pt.postid
inner join tags t
  on pt.tagid = t.id
where v.votetypeid = 6
  and p.closeddate is null
  and t.tagname = ##Tag:string?tagname##
  and p.viewcount < 100

The query is available here. It should get you started.

If you want to search by multiple tags, then you can use the following which is also here:

select row_number() over (order by p.id),
  p.id AS [Post Link], 
  p.tags
from posts p
inner join votes v
  on p.id = v.postid
inner join posttags pt
  on p.id = pt.postid
inner join tags t
  on pt.tagid = t.id
where v.votetypeid = 6
  and p.closeddate is null
  and t.tagname IN (##Tag1:string?tagname##, ##Tag2:string?tagname##)
  and p.viewcount < 100
group by p.id, p.tags
having count(distinct t.tagname) >= 2;