albums_labels
8 rows where label_id = 331
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 522 | 522 | 438 438 | Parkwood Entertainment 331 |
| 3064 | 3064 | 2682 2682 | Parkwood Entertainment 331 |
| 4739 | 4739 | 4135 4135 | Parkwood Entertainment 331 |
| 5922 | 5922 | 5163 5163 | Parkwood Entertainment 331 |
| 6301 | 6301 | 5486 5486 | Parkwood Entertainment 331 |
| 9178 | 9178 | 8027 8027 | Parkwood Entertainment 331 |
| 29435 | 29435 | 26538 26538 | Parkwood Entertainment 331 |
| 30455 | 30455 | 27442 27442 | Parkwood Entertainment 331 |
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) );