0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

select top 50 count(v.postid) as 'Total Votes', v.postid AS [Post Link]
FROM Votes v
	INNER JOIN Posts p ON p.id = v.postid
WHERE 
PostTypeId = 1 
AND v.VoteTypeId=2 
AND p.Tags like LOWER('%<' + ##tagname:string## + '>%')
AND p.CreationDate >= DATEADD(month, -6, GETDATE())
group by v.PostId
order by 'Total Votes' desc

fork query

edited feb 18 20

created nov 26 12 anonymous