albums_artists

7 rows where artist_id = 2480

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3095 3095 2917 2917 2480 2480
10077 10077 9733 9733 2480 2480
11828 11828 11487 11487 2480 2480
12272 12272 11935 11935 2480 2480
12966 12966 12623 12623 2480 2480
13420 13420 13070 13070 2480 2480
14227 14227 13866 13866 2480 2480

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