List of Community Wiki Posts
Get all Question and Answer that are Community Wiki.
Don't list all answers of a Community Wiki Question because they are typically all Community Wiki anyway.
Q&A for linguists, etymologists, and serious English language enthusiasts
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)
order by posts.CreationDate