Find questions migrated from a particular site

0

Please login or register to vote for this query.

(click on this box to dismiss)

Only selects questions that have never been closed.

English Language Learners

Q&A for speakers of other languages learning English

Select
PostId as [Post Link], Score, AnswerCount,
     CASE WHEN AcceptedAnswerId is not null THEN N'✔' ELSE '' END as HasAccepted
From PostHistory
left join Posts on PostHistory.PostId = Posts.Id
Where Posts.PostTypeId = 1
      and Posts.ClosedDate is null
      and PostHistoryTypeId = 36
      and Comment like 'from %' + ##site:string## + '%'
Order by Score desc, AnswerCount desc, Posts.Title, Posts.Id

Enter Parameters

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