0

Please login or register to vote for this query.

(click on this box to dismiss)

Gives some stats on the validity of questions migrated into this site

Q&A for anime and manga fans

-- How valid are migrations?
-- Gives some stats on the validity of questions migrated into this site

Select Count(*) as Immigrants, Count(ClosedDate) as Closed, 100.0*Count(ClosedDate)/Count(*) as PctBadMigrations
   FROM Posts p
   INNER JOIN PostHistory ph ON ph.PostId = p.Id
   WHERE ph.PostHistoryTypeId = 17

fork query

created jun 1 11 jon.doe5752