albums_labels
7 rows where label_id = 3762
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 19174 | 19174 | 17027 17027 | EG 3762 |
| 24880 | 24880 | 22316 22316 | EG 3762 |
| 24881 | 24881 | 22317 22317 | EG 3762 |
| 24882 | 24882 | 22318 22318 | EG 3762 |
| 24883 | 24883 | 22319 22319 | EG 3762 |
| 27003 | 27003 | 24345 24345 | EG 3762 |
| 30252 | 30252 | 27261 27261 | EG 3762 |
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) );