albums_labels
11 rows where label_id = 4340
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 22898 | 22898 | 20444 20444 | Teenbeat 4340 |
| 24326 | 24326 | 21795 21795 | Teenbeat 4340 |
| 25659 | 25659 | 23065 23065 | Teenbeat 4340 |
| 26366 | 26366 | 23742 23742 | Teenbeat 4340 |
| 26691 | 26691 | 24055 24055 | Teenbeat 4340 |
| 26819 | 26819 | 24176 24176 | Teenbeat 4340 |
| 26844 | 26844 | 24199 24199 | Teenbeat 4340 |
| 27286 | 27286 | 24601 24601 | Teenbeat 4340 |
| 27591 | 27591 | 24888 24888 | Teenbeat 4340 |
| 28911 | 28911 | 26097 26097 | Teenbeat 4340 |
| 28914 | 28914 | 26099 26099 | Teenbeat 4340 |
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) );