albums_artists

8 rows where artist_id = 1558

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1740 1740 1641 1641 1558 1558
8227 8227 7907 7907 1558 1558
8228 8228 7908 7908 1558 1558
11543 11543 11205 11205 1558 1558
13570 13570 13218 13218 1558 1558
16409 16409 16095 16095 1558 1558
18070 18070 17782 17782 1558 1558
20601 20601 20435 20435 1558 1558

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