select p1.ParentId as Question_Id, p1.Id as Answer_Id, p2...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

select p1.ParentId as Question_Id, p1.Id as Answer_Id,
       p2.CreationDate as Question_createDate, p1.CreationDate as Answer_date, 
       p2.Title as Question_title, p2.Body as Question, p1.Body as Answer, 
       p2.Score as Question_score, p1.Score as Answer_score, 
       p2.CommentCount as Question_comment, p1.CommentCount as Answer_comment,
       p2.AcceptedAnswerId, p2.AnswerCount, p2.ViewCount, p2.FavoriteCount
from Posts as p1 left join Posts as p2 on p1.ParentId = p2.Id
where p1.OwnerUserId = 1144035 and p1.PostTypeId = 2
order by p1.CreationDate asc

Enter Parameters

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