0

Please login or register to vote for this query.

(click on this box to dismiss)

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

view current version

edited apr 7 20

created apr 7 20 anonymous