Burninate priority list

3

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Overflow

Q&A about the site for professional and enthusiast programmers

select id as [Post Link]
     , title
     , charindex('[', title)
     , charindex(']', title, charindex('[', title)) 
     , case 
       when charindex('[', title) > 0 
       then substring(
              title, 
              charindex('[', title) + 1, 
              charindex(']', title, charindex('[', title)) - charindex('[', title) - 1
             )
       else '?'
       end 
     , (select [count] 
        from tags 
        where tagname = case 
       when charindex('[', title) > 0 
       then substring(
              title, 
              charindex('[', title) + 1, 
              charindex(']', title, charindex('[', title)) - charindex('[', title) - 1
             )
       else '?'
       end) as [Number of Questions] 
     , score
     , (select count(*)
        from votes 
        where postid = p.id
        and votetypeid = 2) as upvotes
     , (select count(*)
        from votes 
        where postid = p.id
        and votetypeid = 3) as downvotes
     , answercount
     , commentcount
     , favoritecount
     , owneruserid as [User Link]
     , lastactivitydate
     , creationdate
from posts p
where p.closeddate is null
and acceptedanswerid is null
and tags like '%<burninate-request>%'
and tags not like '%<status-%'
order by score desc

Enter Parameters

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