albums_labels
7 rows where label_id = 259
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 392 | 392 | 334 334 | Infiné 259 |
| 4441 | 4441 | 3878 3878 | Infiné 259 |
| 10406 | 10406 | 9104 9104 | Infiné 259 |
| 10915 | 10915 | 9553 9553 | Infiné 259 |
| 11378 | 11378 | 9953 9953 | Infiné 259 |
| 12030 | 12030 | 10530 10530 | Infiné 259 |
| 17727 | 17727 | 15669 15669 | Infiné 259 |
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) );