albums_labels
8 rows where label_id = 2488
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 9800 | 9800 | 8574 8574 | ReR 2488 |
| 22559 | 22559 | 20133 20133 | ReR 2488 |
| 24015 | 24015 | 21502 21502 | ReR 2488 |
| 24312 | 24312 | 21781 21781 | ReR 2488 |
| 24858 | 24858 | 22294 22294 | ReR 2488 |
| 25066 | 25066 | 22502 22502 | ReR 2488 |
| 25781 | 25781 | 23185 23185 | ReR 2488 |
| 28091 | 28091 | 25350 25350 | ReR 2488 |
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) );