answers with code blocks


Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping Meta

Q&A about the site for gardeners and landscapers

  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]
  /*coalesce(Post.Tags, Parent.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 '%<code>%')
  Or (Post.Tags like '%<c#>%')
  Or (Post.Tags like '%<python>%')
  Or (Post.Tags like '%<javascript>%')
  Or (Post.Tags like '%<c++>%')
  Or (Post.Tags like '%<java>%')
  Or (Post.Body like '%<error>%')
  Or (Post.Body like '%<while>%')
  Or (Post.Body like '%<for>%')
  Or (Post.Body like '%<string>%')
  Or (Post.Body like '%<integer>%')
  And (Post.PostTypeId = 1)
  And (APost.PostTypeId = 2)
  And (Post.AcceptedAnswerId > 0)

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results