albums_labels
10 rows where label_id = 57
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 65 | 65 | 58 58 | Sony Music Latin 57 |
| 168 | 168 | 144 144 | Sony Music Latin 57 |
| 1042 | 1042 | 893 893 | Sony Music Latin 57 |
| 1570 | 1570 | 1363 1363 | Sony Music Latin 57 |
| 1794 | 1794 | 1566 1566 | Sony Music Latin 57 |
| 2341 | 2341 | 2036 2036 | Sony Music Latin 57 |
| 2850 | 2850 | 2486 2486 | Sony Music Latin 57 |
| 3772 | 3772 | 3293 3293 | Sony Music Latin 57 |
| 4736 | 4736 | 4133 4133 | Sony Music Latin 57 |
| 29767 | 29767 | 26826 26826 | Sony Music Latin 57 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE albums_labels ( album_id integer NOT NULL, label_id integer NOT NULL, FOREIGN KEY(album_id) REFERENCES albums(id), FOREIGN KEY(label_id) REFERENCES labels(id), UNIQUE(album_id,label_id) );