I just started exploring the database schema underlying MusicBrainz, so this might be a trivial question with a simple answer.
Search results such as
show the tracklist for a given release. I have a hard time figuring out the SQL query underlying the connection between a release and tracks on a given release. I looked at various tables but have not been able to discover the respective link structure for formulating the SQL query. Any hints on what specific table(s) (attributes) manage such relationships are very much appreciated.