Q&A about the site for people interested in improving and participating in the patent system
select top 10 PostId, count(*) from Votes v join Posts p on p.Id=v.PostId where v.VoteTypeId in (2,3) and v.CreationDate > getdate()-7 and ( p.Tags like '%<postgresql%' or p.Tags like '%<psql>%' or p.Tags like '%<postgis>%' or p.Tags like '%<plpgsql>%' ) group by v.PostId order by count(*) desc