albums_labels
9 rows where label_id = 652
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1334 | 1334 | 1148 1148 | Luminelle 652 |
| 1479 | 1479 | 1281 1281 | Luminelle 652 |
| 2650 | 2650 | 2311 2311 | Luminelle 652 |
| 3466 | 3466 | 3029 3029 | Luminelle 652 |
| 3990 | 3990 | 3488 3488 | Luminelle 652 |
| 4348 | 4348 | 3797 3797 | Luminelle 652 |
| 4691 | 4691 | 4094 4094 | Luminelle 652 |
| 5403 | 5403 | 4704 4704 | Luminelle 652 |
| 5855 | 5855 | 5103 5103 | Luminelle 652 |
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) );