albums_artists

10 rows where artist_id = 5932

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10480 10480 10140 10140 5932 5932
12811 12811 12469 12469 5932 5932
14592 14592 14238 14238 5932 5932
16378 16378 16065 16065 5932 5932
17378 17378 17081 17081 5932 5932
17379 17379 17082 17082 5932 5932
18386 18386 18115 18115 5932 5932
21755 21755 21647 21647 5932 5932
23415 23415 23311 23311 5932 5932
24437 24437 24326 24326 5932 5932

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