answers with code blocks

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

select
  top 5000
  Post.Id as [Post Link],
  Post.Body as [Question],
  APost.Body as [Answer],
  PostTypes.Name as [Type],
  Post.OwnerUserId as [User Link],
  Post.Score as [Post Score],
  APost.Score as [APost Score],
  Post.CreationDate as [Post Creation Date],
  APost.CreationDate as [APost Creation Date],
  DATEDIFF(HOUR, Post.CreationDate, APost.CreationDate) AS [Time Difference],
  Post.Tags as [Tags]
from Posts as Post INNER JOIN Posts APost ON Post.AcceptedAnswerId = APost.Id
join PostTypes on Post.PostTypeId = PostTypes.Id
left join Posts as Parent on Post.ParentId = Parent.Id
where
  (Post.Body like '%sounds good, it%')

Enter Parameters

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