Stuff
public sql v1 · immutableSELECT m.movie_id, m.name, s.scene_id, p.performer_idFROM movies mLEFT JOIN scenes s USING (movie_id)LEFT JOIN scenes_performers sp USING (scene_id)LEFT JOIN performers p USING (performer_id)ORDER BY movie_id ASC, scene_id ASC