albums_labels
7 rows where label_id = 4569
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 24891 | 24891 | 22327 22327 | March 4569 |
| 25396 | 25396 | 22816 22816 | March 4569 |
| 27366 | 27366 | 24678 24678 | March 4569 |
| 28006 | 28006 | 25275 25275 | March 4569 |
| 28238 | 28238 | 25482 25482 | March 4569 |
| 28564 | 28564 | 25782 25782 | March 4569 |
| 29033 | 29033 | 26201 26201 | March 4569 |
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) );