albums_labels
19 rows where label_id = 1207
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 3257 | 3257 | 2850 2850 | Ribbon Music 1207 |
| 4164 | 4164 | 3645 3645 | Ribbon Music 1207 |
| 6197 | 6197 | 5394 5394 | Ribbon Music 1207 |
| 6563 | 6563 | 5710 5710 | Ribbon Music 1207 |
| 6865 | 6865 | 5982 5982 | Ribbon Music 1207 |
| 9397 | 9397 | 8216 8216 | Ribbon Music 1207 |
| 10558 | 10558 | 9241 9241 | Ribbon Music 1207 |
| 10689 | 10689 | 9356 9356 | Ribbon Music 1207 |
| 10716 | 10716 | 9380 9380 | Ribbon Music 1207 |
| 11791 | 11791 | 10322 10322 | Ribbon Music 1207 |
| 12604 | 12604 | 11060 11060 | Ribbon Music 1207 |
| 13171 | 13171 | 11579 11579 | Ribbon Music 1207 |
| 13636 | 13636 | 12009 12009 | Ribbon Music 1207 |
| 14179 | 14179 | 12504 12504 | Ribbon Music 1207 |
| 14346 | 14346 | 12667 12667 | Ribbon Music 1207 |
| 14652 | 14652 | 12943 12943 | Ribbon Music 1207 |
| 14728 | 14728 | 13007 13007 | Ribbon Music 1207 |
| 15514 | 15514 | 13707 13707 | Ribbon Music 1207 |
| 15757 | 15757 | 13911 13911 | Ribbon Music 1207 |
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) );