Find unusual and rare types of posts


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select post.Id as [Post Link], 
           when post.PostTypeId = 3 then 'Orphaned tag wiki'
           when post.PostTypeId = 6 then 'Moderator nomination'
           when post.PostTypeId = 7 then 'Wiki placeholder'
           when post.PostTypeId = 8 then 'Privelege Wiki'
       as [Type],
       post.OwnerUserId as [User Id]
    from Posts as post
    where post.PostTypeId = 3 or post.PostTypeId > 5;

Enter Parameters

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