select top 10 p.Id, p.Body, q.title, vt.Name from users u...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physical Fitness

Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs

select top 10 p.Id, p.Body, q.title, vt.Name
from users u
join posts p on u.id = p.OwnerUserId
left join posts q on q.id = p.parentId
join Votes v on p.id = v.postId
join VoteTypes vt on v.VoteTypeId = vt.id
where u.id=390819
order by v.CreationDate desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results