Display a site's transition status

Also allow you to record the special redirect strategy for a site.

Based heavily on @jennyd's code.
Eager load hosts to reduce number of queries