albums_labels
5 rows where label_id = 4661
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 25484 | 25484 | 22899 22899 | Rubric 4661 |
| 26687 | 26687 | 24051 24051 | Rubric 4661 |
| 26870 | 26870 | 24223 24223 | Rubric 4661 |
| 27925 | 27925 | 25198 25198 | Rubric 4661 |
| 28553 | 28553 | 25772 25772 | Rubric 4661 |
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) );