Migration stats for travel.SE

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

with migrations as (
  select postID,
  /* 35 = away = > = 62; 36 = here = < = 60 */
  char((36 - posthistoryTypeid) * 2 + 60) + ' ' + substring(comment, charindex('//', comment) + 2, charindex('.com', comment) - charindex('//', comment) + 2) site

  from  postHistory
  where posthistoryTypeid in (35, 36)
)

Select count(postID) num, site
FROM migrations
where site is not null
group by site
order by count(site) desc

Enter Parameters

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