What sort of questions are migrated away?


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for linguists, etymologists, and serious English language enthusiasts

DECLARE @from datetime = getdate() - 90,
        @PostMigratedHere tinyint = 36,
        @PostMigratedAway tinyint = 35,
        @MigrationRejected tinyint = 42,
        @Question tinyint = 1;

select count(*) as 'Migrated away', 
       avg(Score*1.0) 'Avg score',
       avg(AnswerCount*1.0) 'Avg answers',
       avg(CommentCount*1.0) 'Avg comments',
       avg(datediff(hour, p.CreationDate, ph.CreationDate)/24.0) 'Avg age (days)'
from PostHistory ph
     join Posts p on p.Id = PostId
where PostHistoryTypeId In (@PostMigratedAway)
      and ph.CreationDate > @from

Enter Parameters

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