What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 131 Stack Exchange communities.

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 and , 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.

share|improve this question
2  
Got it, I missed that. I'll retract my close vote. –  bluefeet Feb 14 at 19:25

1 Answer 1

up vote 5 down vote accepted

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;
share|improve this answer
    
MM... this would be the best if it was a list of all the questions per tag, kinda like shog showed us the other day. –  Braiam Feb 15 at 20:10
1  
@Braiam The data explorer is available to anyone, feel free to update the query to get it to return any additional info. I quickly wrote this as a start to what was asked for. –  bluefeet Feb 16 at 0:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .