albums_artists
31 rows where artist_id = 1076
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | artist_id |
|---|---|---|---|
| 1146 | 1146 | 1079 1079 | 1076 1076 |
| 1885 | 1885 | 1778 1778 | 1076 1076 |
| 3610 | 3610 | 3415 3415 | 1076 1076 |
| 3843 | 3843 | 3641 3641 | 1076 1076 |
| 6909 | 6909 | 6610 6610 | 1076 1076 |
| 8501 | 8501 | 8169 8169 | 1076 1076 |
| 8706 | 8706 | 8374 8374 | 1076 1076 |
| 10308 | 10308 | 9965 9965 | 1076 1076 |
| 11429 | 11429 | 11090 11090 | 1076 1076 |
| 12284 | 12284 | 11947 11947 | 1076 1076 |
| 12934 | 12934 | 12590 12590 | 1076 1076 |
| 13961 | 13961 | 13604 13604 | 1076 1076 |
| 14176 | 14176 | 13818 13818 | 1076 1076 |
| 14177 | 14177 | 13819 13819 | 1076 1076 |
| 14179 | 14179 | 13820 13820 | 1076 1076 |
| 14701 | 14701 | 14346 14346 | 1076 1076 |
| 15824 | 15824 | 15482 15482 | 1076 1076 |
| 17050 | 17050 | 16747 16747 | 1076 1076 |
| 18052 | 18052 | 17762 17762 | 1076 1076 |
| 18631 | 18631 | 18381 18381 | 1076 1076 |
| 20055 | 20055 | 19872 19872 | 1076 1076 |
| 20167 | 20167 | 19990 19990 | 1076 1076 |
| 20866 | 20866 | 20713 20713 | 1076 1076 |
| 21085 | 21085 | 20950 20950 | 1076 1076 |
| 22084 | 22084 | 21988 21988 | 1076 1076 |
| 23073 | 23073 | 22974 22974 | 1076 1076 |
| 24407 | 24407 | 24295 24295 | 1076 1076 |
| 25758 | 25758 | 25659 25659 | 1076 1076 |
| 25908 | 25908 | 25811 25811 | 1076 1076 |
| 26232 | 26232 | 26130 26130 | 1076 1076 |
| 27047 | 27047 | 26897 26897 | 1076 1076 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE albums_artists ( album_id integer NOT NULL, artist_id integer NOT NULL, FOREIGN KEY(artist_id) REFERENCES artists(id), FOREIGN KEY(album_id) REFERENCES albums(id), UNIQUE(album_id, artist_id) );