1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited mar 27 17 toszter

created mar 15 17 anonymous