0

Please login or register to vote for this query.

(click on this box to dismiss)

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/%'

fork query

edited nov 26 15 Ilmari Karonen

created sep 11 13 Brian Ballsun-Stanton