only upvoted & favourites
Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
select top 100 v.postid AS [Post Link], count(v.postid) as 'Vote count'
from votes v
inner join posts p on p.id=v.postid
where PostTypeId = 2 and VoteTypeId = 2
group by v.postid,p.body
order by 'Vote count' desc