albums_labels
11 rows where label_id = 959
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 2343 | 2343 | 2038 2038 | Ultra 959 |
| 6466 | 6466 | 5626 5626 | Ultra 959 |
| 6631 | 6631 | 5772 5772 | Ultra 959 |
| 8780 | 8780 | 7662 7662 | Ultra 959 |
| 14162 | 14162 | 12489 12489 | Ultra 959 |
| 18056 | 18056 | 15980 15980 | Ultra 959 |
| 23555 | 23555 | 21067 21067 | Ultra 959 |
| 24794 | 24794 | 22231 22231 | Ultra 959 |
| 28623 | 28623 | 25836 25836 | Ultra 959 |
| 30428 | 30428 | 27419 27419 | Ultra 959 |
| 30438 | 30438 | 27429 27429 | Ultra 959 |
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) );