albums_labels
3 rows where label_id = 4371
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 23112 | 23112 | 20644 20644 | Project Blowed 4371 |
| 26797 | 26797 | 24156 24156 | Project Blowed 4371 |
| 28507 | 28507 | 25731 25731 | Project Blowed 4371 |
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) );