Unfortunately there isn't a really easy way to do this one in a query, it would need to be scripted.

We need to make a few changes in this area for version 8. When you select a filter such as inactive/active, it should only be showing the current status for that subscription, not all. The way we store everything for history makes this a bit tough, but I believe I have a couple ideas on how to achieve this.