albums_labels
21 rows where label_id = 1411
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4080 | 4080 | 3573 3573 | Tiny Engines 1411 |
| 4232 | 4232 | 3701 3701 | Tiny Engines 1411 |
| 4296 | 4296 | 3752 3752 | Tiny Engines 1411 |
| 4338 | 4338 | 3788 3788 | Tiny Engines 1411 |
| 4690 | 4690 | 4093 4093 | Tiny Engines 1411 |
| 5195 | 5195 | 4534 4534 | Tiny Engines 1411 |
| 5539 | 5539 | 4822 4822 | Tiny Engines 1411 |
| 5806 | 5806 | 5058 5058 | Tiny Engines 1411 |
| 6091 | 6091 | 5299 5299 | Tiny Engines 1411 |
| 7727 | 7727 | 6723 6723 | Tiny Engines 1411 |
| 7920 | 7920 | 6893 6893 | Tiny Engines 1411 |
| 8047 | 8047 | 7005 7005 | Tiny Engines 1411 |
| 8332 | 8332 | 7263 7263 | Tiny Engines 1411 |
| 8887 | 8887 | 7758 7758 | Tiny Engines 1411 |
| 9047 | 9047 | 7903 7903 | Tiny Engines 1411 |
| 10228 | 10228 | 8951 8951 | Tiny Engines 1411 |
| 10412 | 10412 | 9109 9109 | Tiny Engines 1411 |
| 10747 | 10747 | 9404 9404 | Tiny Engines 1411 |
| 11577 | 11577 | 10129 10129 | Tiny Engines 1411 |
| 12200 | 12200 | 10685 10685 | Tiny Engines 1411 |
| 30097 | 30097 | 27118 27118 | Tiny Engines 1411 |
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) );