demo

0

Please login or register to vote for this query.

(click on this box to dismiss)

Sports

Q&A for participants in team and individual sport activities

select g.*,Users.Id as userId, Users.Reputation, Users.UpVotes as UserUpvotes, Users.DownVotes as UserDownvotes
from Users join 
(select Posts.Id,Posts.AcceptedAnswerId,Posts.ParentId as ParentQqestID,Posts.Score as qScore,Posts.ViewCount as qViewCount,
Posts.OwnerUserId as qAsker,Posts.Body as qBody,Posts.Title as qTitle, Posts.tags as qTags,  
Posts.CommentCount as qCommentCount, Posts.CreationDate as qCreationDate, Posts.LastEditDate as qLastEditDate, Posts.DeletionDate as qDeletionDate,
p.Id as answerId,p.Score as answerScore,p.ViewCount as answerViewCount,
p.OwnerUserId as answerer,p.Body as answerBody,  
p.CommentCount as answerCommentCount, p.CreationDate as AnsweringDate, p.LastActivityDate
from Posts join Posts as p on Posts.Id = p.ParentId where Posts.Id between 600000 and 650000)
as g on Users.Id = g.answerer order by Id

Enter Parameters

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