albums_labels
7 rows where label_id = 2766
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 11733 | 11733 | 10269 10269 | Brille 2766 |
| 13385 | 13385 | 11779 11779 | Brille 2766 |
| 16521 | 16521 | 14590 14590 | Brille 2766 |
| 17415 | 17415 | 15385 15385 | Brille 2766 |
| 17772 | 17772 | 15710 15710 | Brille 2766 |
| 21539 | 21539 | 19205 19205 | Brille 2766 |
| 22872 | 22872 | 20421 20421 | Brille 2766 |
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) );