albums_artists

9 rows where artist_id = 2413

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2988 2988 2816 2816 2413 2413
5818 5818 5551 5551 2413 2413
14461 14461 14104 14104 2413 2413
16685 16685 16375 16375 2413 2413
18237 18237 17959 17959 2413 2413
19888 19888 19699 19699 2413 2413
21916 21916 21813 21813 2413 2413
24986 24986 24878 24878 2413 2413
26327 26327 26222 26222 2413 2413

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