0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select post.Id as [Post Link], 
       case
           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'
       end
       as [Type],
       post.OwnerUserId as [User Id]
    from Posts as post
    where post.PostTypeId = 3 or post.PostTypeId > 5;

fork query

created nov 12 13 tbodt