albums_labels
6 rows where label_id = 614
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1209 | 1209 | 1042 1042 | Running Back 614 |
| 7069 | 7069 | 6156 6156 | Running Back 614 |
| 8070 | 8070 | 7026 7026 | Running Back 614 |
| 9280 | 9280 | 8114 8114 | Running Back 614 |
| 10528 | 10528 | 9214 9214 | Running Back 614 |
| 15694 | 15694 | 13854 13854 | Running Back 614 |
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) );