albums_labels
11 rows where label_id = 1103
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 2843 | 2843 | 2479 2479 | UNO 1103 |
| 8652 | 8652 | 7543 7543 | UNO 1103 |
| 11156 | 11156 | 9763 9763 | UNO 1103 |
| 11922 | 11922 | 10432 10432 | UNO 1103 |
| 12107 | 12107 | 10600 10600 | UNO 1103 |
| 12431 | 12431 | 10902 10902 | UNO 1103 |
| 13098 | 13098 | 11512 11512 | UNO 1103 |
| 13151 | 13151 | 11561 11561 | UNO 1103 |
| 13259 | 13259 | 11664 11664 | UNO 1103 |
| 13869 | 13869 | 12223 12223 | UNO 1103 |
| 15283 | 15283 | 13499 13499 | UNO 1103 |
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) );