albums_labels
7 rows where label_id = 4432
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 23709 | 23709 | 21209 21209 | Level Plane 4432 |
| 25519 | 25519 | 22932 22932 | Level Plane 4432 |
| 26044 | 26044 | 23434 23434 | Level Plane 4432 |
| 26081 | 26081 | 23469 23469 | Level Plane 4432 |
| 26268 | 26268 | 23647 23647 | Level Plane 4432 |
| 26567 | 26567 | 23934 23934 | Level Plane 4432 |
| 27389 | 27389 | 24700 24700 | Level Plane 4432 |
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) );