SELECT m.name, m.directory, c.name as category, st.name as studio, s.movie_id, s.number, sp.scene_id, p.name as performer, p.performer_id,
         (SELECT AVG(rating) from performer_ratings WHERE performer_id = p.performer_id) AS performer_rating,
         (SELECT AVG(rating) from scene_ratings WHERE scene_id = sp.scene_id) AS scene_rating
         FROM scenes_performers sp
         LEFT JOIN performers p USING (performer_id)
         LEFT JOIN scenes s USING (scene_id)
         LEFT JOIN movies m USING (movie_id)
         LEFT JOIN studios st USING (studio_id)
         LEFT JOIN categories c USING (category_id)
         WHERE release_date::TIMESTAMP WITHOUT TIME ZONE <= NOW()
         ORDER by performer_id asc";