albums_artists

6 rows where artist_id = 4411

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6898 6898 6599 6599 4411 4411
12786 12786 12444 12444 4411 4411
16418 16418 16104 16104 4411 4411
17116 17116 16817 16817 4411 4411
19412 19412 19196 19196 4411 4411
23738 23738 23629 23629 4411 4411

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