answers with code blocks


Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

  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
  (Post.Body like '%sounds good, it%')

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results