List of Community Wiki Posts

0

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.

English

Q&A for linguists, etymologists, and serious English language enthusiasts

select  PostTypes.Name, posts.id as [Post Link],
  posts.score as Score,
  posts.ViewCount as [Views] 
 
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.id, posts.posttypeid, posts.Score

Enter Parameters

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