albums_artists

10 rows where artist_id = 2404

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2972 2972 2801 2801 2404 2404
5796 5796 5528 5528 2404 2404
6971 6971 6672 6672 2404 2404
8426 8426 8100 8100 2404 2404
10865 10865 10527 10527 2404 2404
12792 12792 12450 12450 2404 2404
13331 13331 12983 12983 2404 2404
14398 14398 14041 14041 2404 2404
15682 15682 15344 15344 2404 2404
16941 16941 16633 16633 2404 2404

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