albums_labels
8 rows where label_id = 2561
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 10306 | 10306 | 9019 9019 | Duckdown 2561 |
| 15699 | 15699 | 13858 13858 | Duckdown 2561 |
| 16203 | 16203 | 14306 14306 | Duckdown 2561 |
| 17619 | 17619 | 15567 15567 | Duckdown 2561 |
| 18100 | 18100 | 16022 16022 | Duckdown 2561 |
| 19817 | 19817 | 17658 17658 | Duckdown 2561 |
| 19940 | 19940 | 17771 17771 | Duckdown 2561 |
| 23780 | 23780 | 21276 21276 | Duckdown 2561 |
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) );