0

Please login or register to vote for this query.

(click on this box to dismiss)

Provide your user ID and you should get your favourited questions from the most to the least. All questions that have no favourite votes are excluded from the result. Keywords: favourite, favorite, favourites, favorites, favorited, favourited

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

with ps as
(
  select p.Id, count(v.Id) as Favs
  from Posts p
    join Votes v
    on ((v.PostId = p.Id) and (v.VoteTypeId = 5))
  where OwnerUserId = 75642
  group by p.Id
)
select *
from Posts p
  join ps
  on (ps.Id = p.Id)
order by ps.Favs desc

view current version

edited jul 19 12

created jul 19 12 robert.koritnik