albums_labels
9 rows where label_id = 572
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1092 | 1092 | 937 937 | Incienso 572 |
| 1201 | 1201 | 1035 1035 | Incienso 572 |
| 2632 | 2632 | 2295 2295 | Incienso 572 |
| 3372 | 3372 | 2947 2947 | Incienso 572 |
| 4472 | 4472 | 3903 3903 | Incienso 572 |
| 5070 | 5070 | 4431 4431 | Incienso 572 |
| 7023 | 7023 | 6114 6114 | Incienso 572 |
| 29572 | 29572 | 26661 26661 | Incienso 572 |
| 30365 | 30365 | 27360 27360 | Incienso 572 |
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) );