Which questions of mine are most favourited

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

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

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 = ##UserId##
  group by p.Id
)
select p.Id, p.Title, ps.Favs
from Posts p
  join ps
  on (ps.Id = p.Id)
order by ps.Favs desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results