select Votes.CreationDate,count(votes.VoteTypeid) as "No....

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

select Votes.CreationDate,count(votes.VoteTypeid) as "No. of Upvotes",Users.DisplayName
from Users join Posts
on Users.id = Posts.OwnerUserId
join Votes
on Posts.id = Votes.PostId
where Votes.creationdate between '2011-03-13' and '2011-03-19'
and Votes.VoteTypeid = 2 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 Votes.CreationDate,Users.DisplayName 
order by Count(Votes.VoteTypeid) desc,Votes.CreationDate desc

Enter Parameters

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