albums_labels
13 rows where label_id = 1599
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4961 | 4961 | 4335 4335 | DGC 1599 |
| 5873 | 5873 | 5118 5118 | DGC 1599 |
| 7912 | 7912 | 6886 6886 | DGC 1599 |
| 15191 | 15191 | 13421 13421 | DGC 1599 |
| 15579 | 15579 | 13760 13760 | DGC 1599 |
| 17009 | 17009 | 15029 15029 | DGC 1599 |
| 17990 | 17990 | 15917 15917 | DGC 1599 |
| 18137 | 18137 | 16056 16056 | DGC 1599 |
| 19906 | 19906 | 17741 17741 | DGC 1599 |
| 26540 | 26540 | 23909 23909 | DGC 1599 |
| 27223 | 27223 | 24544 24544 | DGC 1599 |
| 28775 | 28775 | 25974 25974 | DGC 1599 |
| 28826 | 28826 | 26020 26020 | DGC 1599 |
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) );