Q&A about the site for Drupal developers and administrators
select top 100 Post.Id as [Post Link], Post.Body, PostTypes.Name as [Type], Post.OwnerUserId as [User Link], Post.Score, Post.CreationDate, coalesce(Post.Tags, Parent.Tags) as [Tags] from Posts as Post join PostTypes on Post.PostTypeId = PostTypes.Id left join Posts as Parent on Post.ParentId = Parent.Id where Post.Body like '%<code>%'