albums_labels
11 rows where label_id = 1722
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 5577 | 5577 | 4855 4855 | Anthology Recordings 1722 |
| 5578 | 5578 | 4856 4856 | Anthology Recordings 1722 |
| 5579 | 5579 | 4857 4857 | Anthology Recordings 1722 |
| 6809 | 6809 | 5936 5936 | Anthology Recordings 1722 |
| 6810 | 6810 | 5937 5937 | Anthology Recordings 1722 |
| 6811 | 6811 | 5938 5938 | Anthology Recordings 1722 |
| 9247 | 9247 | 8088 8088 | Anthology Recordings 1722 |
| 9248 | 9248 | 8089 8089 | Anthology Recordings 1722 |
| 9249 | 9249 | 8090 8090 | Anthology Recordings 1722 |
| 10538 | 10538 | 9223 9223 | Anthology Recordings 1722 |
| 11939 | 11939 | 10447 10447 | Anthology Recordings 1722 |
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) );