SQLAlchemy Group By With Full Child Objects

Imagine the following Media table:

| site       | show_id | time |
| ---------------------|-------|
| CNN        | 1       | 'a'   |
| ABC        | 2       | 'b'   |
| ABC        | 5       | 'c'   |
| CNN        | 3       | 'd'   |
| NBC        | 4       | 'e'   |
| NBC        | 5       | 'f'   |
--------------------------------

I would like to iterate over query results grouped by show_id and have tried this query:

listings = session.query(Media).filter(Media.site == "CNN").group_by(Media.show_id).all()

Here's how I would like to iterate over the results:

for showtimes in listings:
    for show in showtimes:
        print(show.time)

But that query doesn't give me all of the grouped child objects. What am I missing?

from SQLAlchemy Group By With Full Child Objects