albums_labels
25 rows where label_id = 3916
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 20032 | 20032 | 17853 17853 | Lookout! 3916 |
| 22849 | 22849 | 20401 20401 | Lookout! 3916 |
| 22850 | 22850 | 20402 20402 | Lookout! 3916 |
| 22851 | 22851 | 20403 20403 | Lookout! 3916 |
| 24001 | 24001 | 21488 21488 | Lookout! 3916 |
| 24056 | 24056 | 21542 21542 | Lookout! 3916 |
| 24269 | 24269 | 21740 21740 | Lookout! 3916 |
| 24829 | 24829 | 22266 22266 | Lookout! 3916 |
| 24997 | 24997 | 22433 22433 | Lookout! 3916 |
| 25040 | 25040 | 22476 22476 | Lookout! 3916 |
| 26050 | 26050 | 23440 23440 | Lookout! 3916 |
| 26244 | 26244 | 23624 23624 | Lookout! 3916 |
| 26875 | 26875 | 24228 24228 | Lookout! 3916 |
| 27044 | 27044 | 24382 24382 | Lookout! 3916 |
| 27053 | 27053 | 24390 24390 | Lookout! 3916 |
| 27065 | 27065 | 24402 24402 | Lookout! 3916 |
| 27200 | 27200 | 24522 24522 | Lookout! 3916 |
| 27345 | 27345 | 24657 24657 | Lookout! 3916 |
| 27447 | 27447 | 24753 24753 | Lookout! 3916 |
| 27638 | 27638 | 24934 24934 | Lookout! 3916 |
| 27926 | 27926 | 25199 25199 | Lookout! 3916 |
| 28317 | 28317 | 25557 25557 | Lookout! 3916 |
| 28364 | 28364 | 25602 25602 | Lookout! 3916 |
| 28468 | 28468 | 25696 25696 | Lookout! 3916 |
| 28708 | 28708 | 25913 25913 | Lookout! 3916 |
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) );