albums_labels
33 rows where label_id = 3082
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 14069 | 14069 | 12401 12401 | Tomlab 3082 |
| 17662 | 17662 | 15609 15609 | Tomlab 3082 |
| 18689 | 18689 | 16571 16571 | Tomlab 3082 |
| 18904 | 18904 | 16759 16759 | Tomlab 3082 |
| 18908 | 18908 | 16763 16763 | Tomlab 3082 |
| 19211 | 19211 | 17064 17064 | Tomlab 3082 |
| 19539 | 19539 | 17388 17388 | Tomlab 3082 |
| 19980 | 19980 | 17807 17807 | Tomlab 3082 |
| 20255 | 20255 | 18037 18037 | Tomlab 3082 |
| 20404 | 20404 | 18171 18171 | Tomlab 3082 |
| 20534 | 20534 | 18294 18294 | Tomlab 3082 |
| 20625 | 20625 | 18375 18375 | Tomlab 3082 |
| 20717 | 20717 | 18457 18457 | Tomlab 3082 |
| 21969 | 21969 | 19594 19594 | Tomlab 3082 |
| 22104 | 22104 | 19722 19722 | Tomlab 3082 |
| 22781 | 22781 | 20338 20338 | Tomlab 3082 |
| 22988 | 22988 | 20530 20530 | Tomlab 3082 |
| 23505 | 23505 | 21018 21018 | Tomlab 3082 |
| 24278 | 24278 | 21749 21749 | Tomlab 3082 |
| 24405 | 24405 | 21866 21866 | Tomlab 3082 |
| 25438 | 25438 | 22856 22856 | Tomlab 3082 |
| 25951 | 25951 | 23347 23347 | Tomlab 3082 |
| 26054 | 26054 | 23444 23444 | Tomlab 3082 |
| 26100 | 26100 | 23488 23488 | Tomlab 3082 |
| 26252 | 26252 | 23632 23632 | Tomlab 3082 |
| 26314 | 26314 | 23690 23690 | Tomlab 3082 |
| 26328 | 26328 | 23704 23704 | Tomlab 3082 |
| 26475 | 26475 | 23845 23845 | Tomlab 3082 |
| 26745 | 26745 | 24106 24106 | Tomlab 3082 |
| 26980 | 26980 | 24325 24325 | Tomlab 3082 |
| 27350 | 27350 | 24662 24662 | Tomlab 3082 |
| 27394 | 27394 | 24705 24705 | Tomlab 3082 |
| 27395 | 27395 | 24706 24706 | Tomlab 3082 |
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) );