albums_labels
11 rows where label_id = 2334
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8847 | 8847 | 7722 7722 | Fortuna Pop! 2334 |
| 9673 | 9673 | 8459 8459 | Fortuna Pop! 2334 |
| 10500 | 10500 | 9188 9188 | Fortuna Pop! 2334 |
| 11294 | 11294 | 9877 9877 | Fortuna Pop! 2334 |
| 11670 | 11670 | 10215 10215 | Fortuna Pop! 2334 |
| 14715 | 14715 | 12995 12995 | Fortuna Pop! 2334 |
| 15663 | 15663 | 13827 13827 | Fortuna Pop! 2334 |
| 16103 | 16103 | 14218 14218 | Fortuna Pop! 2334 |
| 17150 | 17150 | 15159 15159 | Fortuna Pop! 2334 |
| 17178 | 17178 | 15184 15184 | Fortuna Pop! 2334 |
| 24114 | 24114 | 21592 21592 | Fortuna Pop! 2334 |
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) );