Migration stats for travel.SE

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

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 to meta site
loading Hold tight while we fetch your results