0

Please login or register to vote for this query.

(click on this box to dismiss)

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>'2007-12-31 23:59:59'
            and CreationDate<='2008-12-31 23:59:59'
            and Id%1000=0
      )
      and PostHistoryTypeId=3
    order by PostId;

fork query

edited sep 26 13

created sep 26 13 anonymous