albums_artists

7 rows where artist_id = 5819

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10206 10206 9867 9867 5819 5819
13147 13147 12808 12808 5819 5819
13932 13932 13574 13574 5819 5819
16972 16972 16664 16664 5819 5819
19352 19352 19135 19135 5819 5819
24818 24818 24701 24701 5819 5819
25446 25446 25346 25346 5819 5819

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