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