albums_labels
11 rows where label_id = 1441
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4235 | 4235 | 3703 3703 | Orchid Tapes 1441 |
| 4526 | 4526 | 3950 3950 | Orchid Tapes 1441 |
| 8611 | 8611 | 7509 7509 | Orchid Tapes 1441 |
| 8679 | 8679 | 7568 7568 | Orchid Tapes 1441 |
| 10362 | 10362 | 9067 9067 | Orchid Tapes 1441 |
| 10525 | 10525 | 9212 9212 | Orchid Tapes 1441 |
| 11406 | 11406 | 9978 9978 | Orchid Tapes 1441 |
| 11740 | 11740 | 10275 10275 | Orchid Tapes 1441 |
| 11980 | 11980 | 10487 10487 | Orchid Tapes 1441 |
| 12199 | 12199 | 10684 10684 | Orchid Tapes 1441 |
| 13115 | 13115 | 11527 11527 | Orchid Tapes 1441 |
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) );