How can I get unique track?

MusicBrainz Development
,
1

I have local musicbrainz database. Here is the screenshot from track table.
As you can see, there are few tracks with the same name, length, artist_credit etc etc. What are the differents between them? I see differents in gid uuid column. But in fact all other columns are the same.
How can I get unique tracks?

Screenshot_289
Screenshot_2891320Ă—646 56.4 KB

2

Tracks are each appearance of a recording in a specific medium of a release (as you can see, the medium ID is also different for each track). If you want “unique tracks”, you probably want to look at recordings instead.

4 Likes
3

You should have a look at this schema, it shows the relations between the different tables:

1 Like
4

Thanks I saw that. Just a little bit difficult to understand what does mean some fields. In wiki there are brief explanation for a couple of tables, but not for all of them