albums_labels
9 rows where label_id = 2645
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 10845 | 10845 | 9492 9492 | GOOD 2645 |
| 12668 | 12668 | 11121 11121 | GOOD 2645 |
| 13256 | 13256 | 11661 11661 | GOOD 2645 |
| 13565 | 13565 | 11946 11946 | GOOD 2645 |
| 14124 | 14124 | 12451 12451 | GOOD 2645 |
| 15293 | 15293 | 13507 13507 | GOOD 2645 |
| 15769 | 15769 | 13919 13919 | GOOD 2645 |
| 16622 | 16622 | 14677 14677 | GOOD 2645 |
| 18164 | 18164 | 16080 16080 | GOOD 2645 |
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) );