albums_labels
8 rows where label_id = 1225
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 3319 | 3319 | 2900 2900 | Tough Love 1225 |
| 7614 | 7614 | 6630 6630 | Tough Love 1225 |
| 8076 | 8076 | 7031 7031 | Tough Love 1225 |
| 9375 | 9375 | 8197 8197 | Tough Love 1225 |
| 12301 | 12301 | 10780 10780 | Tough Love 1225 |
| 12371 | 12371 | 10845 10845 | Tough Love 1225 |
| 14788 | 14788 | 13059 13059 | Tough Love 1225 |
| 16003 | 16003 | 14127 14127 | Tough Love 1225 |
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) );