albums_labels
6 rows where label_id = 4202
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 21818 | 21818 | 19455 19455 | Playhouse 4202 |
| 21982 | 21982 | 19607 19607 | Playhouse 4202 |
| 23078 | 23078 | 20615 20615 | Playhouse 4202 |
| 23997 | 23997 | 21484 21484 | Playhouse 4202 |
| 24690 | 24690 | 22134 22134 | Playhouse 4202 |
| 26120 | 26120 | 23507 23507 | Playhouse 4202 |
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) );