albums_artists

5 rows where artist_id = 2581

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3246 3246 3063 3063 2581 2581
7688 7688 7382 7382 2581 2581
11066 11066 10726 10726 2581 2581
13886 13886 13529 13529 2581 2581
15953 15953 15614 15614 2581 2581

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