albums_artists

5 rows where artist_id = 3167

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4288 4288 4083 4083 3167 3167
11993 11993 11652 11652 3167 3167
14933 14933 14585 14585 3167 3167
16115 16115 15787 15787 3167 3167
18474 18474 18206 18206 3167 3167

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