albums_labels
13 rows where label_id = 336
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 543 | 543 | 455 455 | Fantasy 336 |
| 1462 | 1462 | 1268 1268 | Fantasy 336 |
| 2221 | 2221 | 1933 1933 | Fantasy 336 |
| 2355 | 2355 | 2048 2048 | Fantasy 336 |
| 4480 | 4480 | 3911 3911 | Fantasy 336 |
| 4735 | 4735 | 4132 4132 | Fantasy 336 |
| 5802 | 5802 | 5054 5054 | Fantasy 336 |
| 10354 | 10354 | 9059 9059 | Fantasy 336 |
| 12389 | 12389 | 10862 10862 | Fantasy 336 |
| 15745 | 15745 | 13902 13902 | Fantasy 336 |
| 17258 | 17258 | 15254 15254 | Fantasy 336 |
| 20191 | 20191 | 17985 17985 | Fantasy 336 |
| 21941 | 21941 | 19567 19567 | Fantasy 336 |
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) );