List of Community Wiki Posts


Please login or register to vote for this query.

(click on this box to dismiss)

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

select  PostTypes.Name, as [Post Link],
        posts.score as Score,
from posts 
inner join 
on posts.posttypeid = PostTypes.ID
left join posts as ParentPosts
on posts.ParentId =
where posts.posttypeid in(1,2) and
      not (Posts.CommunityOwnedDate is null) and
      (ParentPosts.CommunityOwnedDate is null)
order by posts.CreationDate

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results