albums_artists

7 rows where artist_id = 2061

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2430 2430 2279 2279 2061 2061
13563 13563 13211 13211 2061 2061
13564 13564 13212 13212 2061 2061
16717 16717 16408 16408 2061 2061
18257 18257 17979 17979 2061 2061
20014 20014 19829 19829 2061 2061
26818 26818 26682 26682 2061 2061

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