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.

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results