albums_artists

6 rows where artist_id = 2616

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3314 3314 3130 3130 2616 2616
8429 8429 8102 8102 2616 2616
8909 8909 8573 8573 2616 2616
13559 13559 13207 13207 2616 2616
14083 14083 13728 13728 2616 2616
14444 14444 14087 14087 2616 2616

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