0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

--select title, viewcount, favoritecount
--  from posts
--   where tags like '%oracle%'
--     order by viewcount desc, favoritecount desc;
     
     
--select * from voteTypes;


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

fork query

edited apr 8 15 gvenzl

created apr 8 15 anonymous