albums_labels
8 rows where label_id = 3684
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 18721 | 18721 | 16602 16602 | Eenie Meenie 3684 |
| 20102 | 20102 | 17911 17911 | Eenie Meenie 3684 |
| 21033 | 21033 | 18743 18743 | Eenie Meenie 3684 |
| 23392 | 23392 | 20916 20916 | Eenie Meenie 3684 |
| 23491 | 23491 | 21005 21005 | Eenie Meenie 3684 |
| 24746 | 24746 | 22185 22185 | Eenie Meenie 3684 |
| 24747 | 24747 | 22186 22186 | Eenie Meenie 3684 |
| 26910 | 26910 | 24261 24261 | Eenie Meenie 3684 |
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) );