albums_labels
15 rows where label_id = 2344
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8882 | 8882 | 7753 7753 | Melodic 2344 |
| 13604 | 13604 | 11982 11982 | Melodic 2344 |
| 13728 | 13728 | 12092 12092 | Melodic 2344 |
| 13969 | 13969 | 12313 12313 | Melodic 2344 |
| 14993 | 14993 | 13240 13240 | Melodic 2344 |
| 16828 | 16828 | 14860 14860 | Melodic 2344 |
| 17605 | 17605 | 15554 15554 | Melodic 2344 |
| 20693 | 20693 | 18438 18438 | Melodic 2344 |
| 21700 | 21700 | 19350 19350 | Melodic 2344 |
| 22012 | 22012 | 19636 19636 | Melodic 2344 |
| 22093 | 22093 | 19711 19711 | Melodic 2344 |
| 22122 | 22122 | 19739 19739 | Melodic 2344 |
| 23824 | 23824 | 21320 21320 | Melodic 2344 |
| 24459 | 24459 | 21920 21920 | Melodic 2344 |
| 27788 | 27788 | 25072 25072 | Melodic 2344 |
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) );