0

Please login or register to vote for this query.

(click on this box to dismiss)

Get a user's Question and Answer that are Community Wiki but not closed. Don't list answers of a Community Wiki Question because they cannot be removed from Community Wiki Status without removing the Question's Community Wiki Status.

Q&A for professional and enthusiast programmers

select  PostTypes.Name, 
        posts.id as [Post Link],
        posts.score as Score,
        posts.CreationDate
from posts 
inner join 
PostTypes 
on posts.posttypeid = PostTypes.ID
left join posts as ParentPosts
on posts.ParentId = ParentPosts.id

where posts.posttypeid in(1,2) and
      Posts.ClosedDate is null and
      ParentPosts.ClosedDate is null and
      not (Posts.CommunityOwnedDate is null) and
      (ParentPosts.CommunityOwnedDate is null) And
      posts.OwnerUserId = ##UserId##
order by posts.CreationDate

fork query

edited nov 29 12

created nov 28 12 davrob60