Because these need fixing *again*... :-(
Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games
select Post.Id as [Post Link], PostTypes.Name as [Type], case when Author.Id is null then Post.OwnerDisplayName else 'site://users/' + cast(Author.Id as varchar) + '|' + Author.DisplayName end as [Author], Post.Score, Post.CreationDate, coalesce(Post.ViewCount, Parent.ViewCount) as [Views], 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 left join Users as Author on Post.OwnerUserId = Author.Id where Post.Body like '%href="http://community.wizards.com/forum/%'