0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and power users of the Android operating system

select
  top 50000
  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%')
  And (APost.PostTypeId = 2)

fork query

edited sep 25 20 anonymous

created nov 3 15 Ilmari Karonen