albums_labels
7 rows where label_id = 610
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1187 | 1187 | 1021 1021 | 88rising 610 |
| 4305 | 4305 | 3759 3759 | 88rising 610 |
| 5368 | 5368 | 4674 4674 | 88rising 610 |
| 5770 | 5770 | 5022 5022 | 88rising 610 |
| 6072 | 6072 | 5283 5283 | 88rising 610 |
| 6421 | 6421 | 5590 5590 | 88rising 610 |
| 6515 | 6515 | 5668 5668 | 88rising 610 |
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) );