albums_artists

9 rows where artist_id = 6421

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
11581 11581 11243 11243 6421 6421
14162 14162 13805 13805 6421 6421
17040 17040 16738 16738 6421 6421
17041 17041 16739 16739 6421 6421
17042 17042 16740 16740 6421 6421
20062 20062 19880 19880 6421 6421
22408 22408 22314 22314 6421 6421
24522 24522 24403 24403 6421 6421
26314 26314 26210 26210 6421 6421

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