Search favorites

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select distinct v.postid as [Post Link]
     , v.userid as [User Link]
     , v.creationdate as [favorited]
     , (select max(creationdate)
            from posthistory 
            where postid= a.id
            and posthistorytypeid = 5 -- edit body
        ) as [edited]
     , 'site://q/' + cast(a.id as nvarchar) +'|Answer Link'
from votes v 
inner join posts a on a.parentid = v.postid
where v.votetypeid = 5 -- favorite
and v.userid = ##userid:int?1179880##
and a.creationdate > v.creationdate 
and exists (select 1
            from posthistory 
            where postid= a.id
            and posthistorytypeid = 5 -- edit body
            )

Enter Parameters

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