albums_artists

5 rows where artist_id = 5900

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10423 10423 10081 10081 5900 5900
13051 13051 12713 12713 5900 5900
14925 14925 14579 14579 5900 5900
15879 15879 15535 15535 5900 5900
16640 16640 16329 16329 5900 5900

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