select PostId,Text,CreationDate from PostHistory where Po...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity Meta

Q&A about the site for committed Christians, experts in Christianity and those interested in learning more

select PostId,Text,CreationDate
  from PostHistory
    where PostId in
      (select Id
        from Posts
          where LastEditDate is not null
            and PostTypeId=1
            and CreationDate>'2011-12-31 23:59:59'
            and CreationDate<='2012-12-31 23:59:59'
            and Id%20000=0
      )
      and PostHistoryTypeId=3
    order by PostId;

Enter Parameters

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