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)) 
     , 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