albums_labels
20 rows where label_id = 2425
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 9415 | 9415 | 8232 8232 | Software 2425 |
| 9936 | 9936 | 8690 8690 | Software 2425 |
| 10677 | 10677 | 9345 9345 | Software 2425 |
| 11397 | 11397 | 9969 9969 | Software 2425 |
| 11828 | 11828 | 10351 10351 | Software 2425 |
| 11885 | 11885 | 10401 10401 | Software 2425 |
| 12189 | 12189 | 10675 10675 | Software 2425 |
| 12497 | 12497 | 10963 10963 | Software 2425 |
| 12731 | 12731 | 11178 11178 | Software 2425 |
| 13228 | 13228 | 11634 11634 | Software 2425 |
| 13265 | 13265 | 11670 11670 | Software 2425 |
| 13496 | 13496 | 11884 11884 | Software 2425 |
| 13545 | 13545 | 11928 11928 | Software 2425 |
| 13727 | 13727 | 12091 12091 | Software 2425 |
| 13826 | 13826 | 12182 12182 | Software 2425 |
| 14321 | 14321 | 12644 12644 | Software 2425 |
| 14443 | 14443 | 12759 12759 | Software 2425 |
| 14978 | 14978 | 13225 13225 | Software 2425 |
| 15276 | 15276 | 13493 13493 | Software 2425 |
| 15898 | 15898 | 14036 14036 | Software 2425 |
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) );