0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for science fiction and fantasy enthusiasts

SELECT P.Id, P.ParentId, P.OwnerUserId, P.AcceptedAnswerId, P.Score, P.Body, P.CreationDate, C.UserId CommentUserId, C.Text CommentText, C.CreationDate CommentCreationDate, (SELECT Name FROM PostTypes AS PT WHERE PT.Id = P.PostTypeId) PostType FROM Posts AS P FULL OUTER JOIN Comments AS C ON C.PostId = P.Id WHERE P.Id = 419619 OR P.ParentId = 419619

fork query

edited nov 28 23

created nov 16 23 anonymous