Q&A for professional and enthusiast programmers
select postid as [Post Link] , v.creationdate as [Favorited on] , p.score as [Post score] , case when p.acceptedanswerid is not null then 'accepted' else null end as [accept] , p.owneruserid as [User Link] from votes v inner join posts p on p.id = v.postid where userid = 1286760 and votetypeid = 5 order by v.creationdate desc