Questions with RAW tag at first revision and no RAW tag now

1

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 Posts.Id as [Post Link], Posts.Tags, PostInits.Text as [Initial Tags]
from Posts
inner join (
  select PostId, Text
  from PostHistory
  where PostHistoryTypeId = 3
  and Text like '%rules-as-written%'
) as PostInits on Posts.Id = PostInits.PostId
where Posts.Tags not like '%rules-as-written%'

Enter Parameters

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