0

Please login or register to vote for this query.

(click on this box to dismiss)

A list of Stack Overflow questions with outstanding close votes, sorted by number of votes.

Q&A for scientists using computers to solve scientific problems

-- Stack Overflow questions with outstanding close votes
-- A list of Stack Overflow questions with outstanding close votes, sorted by number of votes.


select
  Posts.Id as [Post Link],
  avg(Posts.Score) as [Score],
  count(*) as [Close Votes],
  max(Votes.CreationDate) as [Last Vote],
  min(Votes.CreationDate) as [First Vote]  
from Posts
inner join Votes on Posts.Id=Votes.PostId
where Votes.VoteTypeId=6 and Posts.ClosedDate is NULL and Posts.Tags LIKE '%<php>%'
group by Posts.Id
order by [Close Votes] desc, [Score] asc, [Last Vote] desc

fork query

edited feb 18 13 anonymous

created oct 25 11 The Blue Bomber