albums_labels
16 rows where label_id = 124
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 144 | 144 | 122 122 | New Amsterdam 124 |
| 1314 | 1314 | 1129 1129 | New Amsterdam 124 |
| 1465 | 1465 | 1271 1271 | New Amsterdam 124 |
| 2067 | 2067 | 1800 1800 | New Amsterdam 124 |
| 3020 | 3020 | 2642 2642 | New Amsterdam 124 |
| 3189 | 3189 | 2788 2788 | New Amsterdam 124 |
| 3615 | 3615 | 3152 3152 | New Amsterdam 124 |
| 3973 | 3973 | 3472 3472 | New Amsterdam 124 |
| 4733 | 4733 | 4131 4131 | New Amsterdam 124 |
| 11357 | 11357 | 9936 9936 | New Amsterdam 124 |
| 11961 | 11961 | 10468 10468 | New Amsterdam 124 |
| 13039 | 13039 | 11454 11454 | New Amsterdam 124 |
| 13420 | 13420 | 11813 11813 | New Amsterdam 124 |
| 13808 | 13808 | 12165 12165 | New Amsterdam 124 |
| 15182 | 15182 | 13412 13412 | New Amsterdam 124 |
| 29474 | 29474 | 26572 26572 | New Amsterdam 124 |
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) );