albums_artists

6 rows where artist_id = 45

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
50 50 49 49 45 45
2819 2819 2654 2654 45 45
3556 3556 3359 3359 45 45
5390 5390 5138 5138 45 45
6372 6372 6083 6083 45 45
9449 9449 9102 9102 45 45

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