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
posts.id as [Post Link],
posts.score as Score,
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