0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

-- Enter Query Title
-- Enter Query Description

select v.postid as [Post Link], count(*) as CloseVotes from votes v
join posts p on p.id = v.postid
where v.votetypeid = 6
and p.ClosedDate is null
group by v.postid
order by CloseVotes desc

fork query

created aug 8 10 krock