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";