select Votes.creationdate, Users.id,Users.DisplayName,cou...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select Votes.creationdate, Users.id,Users.DisplayName,count(votes.VoteTypeid) as "No. of Downvotes"
from Users join Posts
on Users.id = Posts.OwnerUserId
join Votes
on Posts.id = Votes.PostId
where Votes.creationdate between '2011-04-10' and '2011-04-16'
and Votes.VoteTypeid = 3 and users.id in ('29407','22656','616700','573261','157882','17034','115145','50079','34397','505088',
'31671','656769','138475','61974','279627','23354','413501','329769','14637','218196','151292','14860','65358','166749','103167')
group by Users.DisplayName, Users.id,Votes.creationdate
order by Count(Votes.VoteTypeid) desc

Enter Parameters

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