List of Non-Closed Community Wiki Posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Get all Question and Answer that are Community Wiki and still open. Don't list all answers of a Community Wiki Question because they are all Community Wiki anyway.

Stack Overflow

Q&A for professional and enthusiast programmers

select  PostTypes.Name, 
        posts.id as [Post Link],
        posts.score as Score,
        posts.CreationDate, 
        Posts.CommunityOwnedDate
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) 
order by posts.CreationDate

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results