albums_artists

5 rows where artist_id = 3099

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4160 4160 3959 3959 3099 3099
8505 8505 8172 8172 3099 3099
10648 10648 10315 10315 3099 3099
11875 11875 11533 11533 3099 3099
12561 12561 12221 12221 3099 3099

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