albums_labels
30 rows where label_id = 1522
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4630 | 4630 | 4041 4041 | Goner 1522 |
| 4875 | 4875 | 4260 4260 | Goner 1522 |
| 7665 | 7665 | 6675 6675 | Goner 1522 |
| 8615 | 8615 | 7512 7512 | Goner 1522 |
| 9020 | 9020 | 7879 7879 | Goner 1522 |
| 9731 | 9731 | 8513 8513 | Goner 1522 |
| 10132 | 10132 | 8865 8865 | Goner 1522 |
| 11126 | 11126 | 9739 9739 | Goner 1522 |
| 11413 | 11413 | 9984 9984 | Goner 1522 |
| 11955 | 11955 | 10462 10462 | Goner 1522 |
| 12071 | 12071 | 10569 10569 | Goner 1522 |
| 13179 | 13179 | 11587 11587 | Goner 1522 |
| 13489 | 13489 | 11877 11877 | Goner 1522 |
| 13833 | 13833 | 12189 12189 | Goner 1522 |
| 14309 | 14309 | 12632 12632 | Goner 1522 |
| 15162 | 15162 | 13393 13393 | Goner 1522 |
| 15218 | 15218 | 13443 13443 | Goner 1522 |
| 15927 | 15927 | 14062 14062 | Goner 1522 |
| 16111 | 16111 | 14225 14225 | Goner 1522 |
| 17213 | 17213 | 15212 15212 | Goner 1522 |
| 17462 | 17462 | 15427 15427 | Goner 1522 |
| 17606 | 17606 | 15554 15554 | Goner 1522 |
| 17831 | 17831 | 15766 15766 | Goner 1522 |
| 17832 | 17832 | 15767 15767 | Goner 1522 |
| 18281 | 18281 | 16189 16189 | Goner 1522 |
| 18425 | 18425 | 16328 16328 | Goner 1522 |
| 20386 | 20386 | 18155 18155 | Goner 1522 |
| 21089 | 21089 | 18796 18796 | Goner 1522 |
| 29341 | 29341 | 26460 26460 | Goner 1522 |
| 30132 | 30132 | 27152 27152 | Goner 1522 |
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) );