albums_labels
14 rows where label_id = 424
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 725 | 725 | 612 612 | American Dreams 424 |
| 1196 | 1196 | 1029 1029 | American Dreams 424 |
| 1667 | 1667 | 1450 1450 | American Dreams 424 |
| 2086 | 2086 | 1816 1816 | American Dreams 424 |
| 2439 | 2439 | 2125 2125 | American Dreams 424 |
| 2490 | 2490 | 2172 2172 | American Dreams 424 |
| 3453 | 3453 | 3018 3018 | American Dreams 424 |
| 3773 | 3773 | 3294 3294 | American Dreams 424 |
| 29377 | 29377 | 26489 26489 | American Dreams 424 |
| 29583 | 29583 | 26671 26671 | American Dreams 424 |
| 29741 | 29741 | 26804 26804 | American Dreams 424 |
| 29854 | 29854 | 26901 26901 | American Dreams 424 |
| 30142 | 30142 | 27162 27162 | American Dreams 424 |
| 30420 | 30420 | 27411 27411 | American Dreams 424 |
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) );