albums_labels
13 rows where label_id = 574
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1098 | 1098 | 943 943 | Modern Love 574 |
| 2091 | 2091 | 1819 1819 | Modern Love 574 |
| 2506 | 2506 | 2185 2185 | Modern Love 574 |
| 3903 | 3903 | 3411 3411 | Modern Love 574 |
| 5298 | 5298 | 4616 4616 | Modern Love 574 |
| 8235 | 8235 | 7175 7175 | Modern Love 574 |
| 9183 | 9183 | 8030 8030 | Modern Love 574 |
| 13961 | 13961 | 12306 12306 | Modern Love 574 |
| 13988 | 13988 | 12327 12327 | Modern Love 574 |
| 15116 | 15116 | 13351 13351 | Modern Love 574 |
| 15335 | 15335 | 13547 13547 | Modern Love 574 |
| 15959 | 15959 | 14089 14089 | Modern Love 574 |
| 16402 | 16402 | 14484 14484 | Modern Love 574 |
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) );