albums_labels
11 rows where label_id = 797
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1809 | 1809 | 1583 1583 | Entertainment One 797 |
| 6897 | 6897 | 6011 6011 | Entertainment One 797 |
| 8057 | 8057 | 7014 7014 | Entertainment One 797 |
| 8522 | 8522 | 7430 7430 | Entertainment One 797 |
| 8796 | 8796 | 7677 7677 | Entertainment One 797 |
| 8872 | 8872 | 7743 7743 | Entertainment One 797 |
| 9900 | 9900 | 8659 8659 | Entertainment One 797 |
| 9925 | 9925 | 8680 8680 | Entertainment One 797 |
| 10082 | 10082 | 8821 8821 | Entertainment One 797 |
| 11758 | 11758 | 10292 10292 | Entertainment One 797 |
| 13075 | 13075 | 11489 11489 | Entertainment One 797 |
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) );