albums_labels
7 rows where label_id = 4857
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 26845 | 26845 | 24200 24200 | Force Inc 4857 |
| 27246 | 27246 | 24563 24563 | Force Inc 4857 |
| 27377 | 27377 | 24689 24689 | Force Inc 4857 |
| 27742 | 27742 | 25029 25029 | Force Inc 4857 |
| 28182 | 28182 | 25431 25431 | Force Inc 4857 |
| 28242 | 28242 | 25486 25486 | Force Inc 4857 |
| 28948 | 28948 | 26127 26127 | Force Inc 4857 |
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) );