albums_artists

6 rows where artist_id = 9009

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
18617 18617 18366 18366 9009 9009
18769 18769 18527 18527 9009 9009
21997 21997 21897 21897 9009 9009
23656 23656 23549 23549 9009 9009
24930 24930 24821 24821 9009 9009
26140 26140 26037 26037 9009 9009

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