albums_artists

13 rows where artist_id = 2078

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2459 2459 2308 2308 2078 2078
4991 4991 4755 4755 2078 2078
5121 5121 4878 4878 2078 2078
7367 7367 7068 7068 2078 2078
9081 9081 8742 8742 2078 2078
10175 10175 9835 9835 2078 2078
12446 12446 12106 12106 2078 2078
13677 13677 13326 13326 2078 2078
14948 14948 14598 14598 2078 2078
15563 15563 15221 15221 2078 2078
17598 17598 17302 17302 2078 2078
19109 19109 18885 18885 2078 2078
20606 20606 20442 20442 2078 2078

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);