albums_artists

8 rows where artist_id = 3339

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4577 4577 4360 4360 3339 3339
8731 8731 8398 8398 3339 3339
16718 16718 16409 16409 3339 3339
20153 20153 19976 19976 3339 3339
20867 20867 20713 20713 3339 3339
23020 23020 22924 22924 3339 3339
25802 25802 25703 25703 3339 3339
26332 26332 26226 26226 3339 3339

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