albums_labels
9 rows where label_id = 1409
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4075 | 4075 | 3569 3569 | Pi 1409 |
| 6609 | 6609 | 5751 5751 | Pi 1409 |
| 7195 | 7195 | 6262 6262 | Pi 1409 |
| 7812 | 7812 | 6800 6800 | Pi 1409 |
| 8400 | 8400 | 7316 7316 | Pi 1409 |
| 8669 | 8669 | 7559 7559 | Pi 1409 |
| 19885 | 19885 | 17722 17722 | Pi 1409 |
| 20226 | 20226 | 18013 18013 | Pi 1409 |
| 25591 | 25591 | 22998 22998 | Pi 1409 |
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) );