albums_artists

6 rows where artist_id = 3819

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5597 5597 5337 5337 3819 3819
8898 8898 8562 8562 3819 3819
10969 10969 10628 10628 3819 3819
11457 11457 11120 11120 3819 3819
12325 12325 11988 11988 3819 3819
13291 13291 12945 12945 3819 3819

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