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, p.CreationDate from votes v
join posts p on p.id = v.postid
where v.votetypeid = 6
and p.ClosedDate is null
group by v.postid, p.CreationDate
order by CloseVotes desc, p.CreationDate desc

fork query

created aug 8 10 krock