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.

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

fork query

edited mar 1 13

created nov 28 12 davrob60