albums_artists

7 rows where artist_id = 2819

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3665 3665 3469 3469 2819 2819
3666 3666 3470 3470 2819 2819
3667 3667 3471 3471 2819 2819
6442 6442 6150 6150 2819 2819
7292 7292 6997 6997 2819 2819
10099 10099 9755 9755 2819 2819
11205 11205 10867 10867 2819 2819

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