albums_labels
8 rows where label_id = 3783
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 19329 | 19329 | 17181 17181 | Huume 3783 |
| 20672 | 20672 | 18419 18419 | Huume 3783 |
| 21371 | 21371 | 19053 19053 | Huume 3783 |
| 22082 | 22082 | 19700 19700 | Huume 3783 |
| 22654 | 22654 | 20219 20219 | Huume 3783 |
| 23150 | 23150 | 20681 20681 | Huume 3783 |
| 23151 | 23151 | 20682 20682 | Huume 3783 |
| 25270 | 25270 | 22695 22695 | Huume 3783 |
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) );