SELECT p.title, vt.name, count(1) votes FROM Posts p INNE...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT p.title, vt.name, count(1) votes
  FROM Posts p INNER JOIN Votes v ON p.Id = v.PostId,
       VoteTypes vt
    where vt.Name NOT IN ('DownMod', 'Offensive', 'Deletion', 'Spam')
      and p.Tags like '%oracle%'
      and v.VoteTypeId=vt.Id
    group by p.title, vt.name
     order by votes desc;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results