albums_artists

7 rows where artist_id = 74

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
79 79 77 77 74 74
1863 1863 1758 1758 74 74
5283 5283 5036 5036 74 74
7496 7496 7190 7190 74 74
9531 9531 9186 9186 74 74
10497 10497 10157 10157 74 74
27374 27374 27202 27202 74 74

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