albums_labels
9 rows where label_id = 131
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 154 | 154 | 132 132 | Peaceville 131 |
| 272 | 272 | 236 236 | Peaceville 131 |
| 714 | 714 | 602 602 | Peaceville 131 |
| 4115 | 4115 | 3606 3606 | Peaceville 131 |
| 4521 | 4521 | 3945 3945 | Peaceville 131 |
| 8430 | 8430 | 7344 7344 | Peaceville 131 |
| 13547 | 13547 | 11930 11930 | Peaceville 131 |
| 20411 | 20411 | 18177 18177 | Peaceville 131 |
| 23160 | 23160 | 20691 20691 | Peaceville 131 |
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) );