declare @userId as int = ##userId##; select q.Title, a.C...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

declare @userId as int = ##userId##;

select q.Title, a.CreationDate, a.Score, 'http://stackoverflow.com/a/' + cast(q.Id as nvarchar) as Permalink
from posts a
join posts q on a.ParentId = q.Id
join votes v on a.Id = v.PostId
where a.PostTypeId = 2
and q.PostTypeId = 1
and v.VoteTypeId = 1
and a.owneruserid = @userId
order by score desc;

Enter Parameters

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