albums_labels
19 rows where label_id = 420
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 716 | 716 | 604 604 | G.O.O.D. Music 420 |
| 868 | 868 | 741 741 | G.O.O.D. Music 420 |
| 1626 | 1626 | 1412 1412 | G.O.O.D. Music 420 |
| 3104 | 3104 | 2712 2712 | G.O.O.D. Music 420 |
| 3712 | 3712 | 3235 3235 | G.O.O.D. Music 420 |
| 5469 | 5469 | 4760 4760 | G.O.O.D. Music 420 |
| 5891 | 5891 | 5135 5135 | G.O.O.D. Music 420 |
| 5957 | 5957 | 5193 5193 | G.O.O.D. Music 420 |
| 5983 | 5983 | 5218 5218 | G.O.O.D. Music 420 |
| 6028 | 6028 | 5255 5255 | G.O.O.D. Music 420 |
| 6117 | 6117 | 5322 5322 | G.O.O.D. Music 420 |
| 6385 | 6385 | 5558 5558 | G.O.O.D. Music 420 |
| 6677 | 6677 | 5812 5812 | G.O.O.D. Music 420 |
| 7352 | 7352 | 6393 6393 | G.O.O.D. Music 420 |
| 7980 | 7980 | 6946 6946 | G.O.O.D. Music 420 |
| 8885 | 8885 | 7756 7756 | G.O.O.D. Music 420 |
| 9419 | 9419 | 8236 8236 | G.O.O.D. Music 420 |
| 9484 | 9484 | 8294 8294 | G.O.O.D. Music 420 |
| 9671 | 9671 | 8457 8457 | G.O.O.D. Music 420 |
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) );