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 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) ORDER by performer_id as