albums_artists

8 rows where artist_id = 4629

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7370 7370 7071 7071 4629 4629
8659 8659 8324 8324 4629 4629
12523 12523 12183 12183 4629 4629
15013 15013 14666 14666 4629 4629
16012 16012 15677 15677 4629 4629
16350 16350 16035 16035 4629 4629
20637 20637 20474 20474 4629 4629
22173 22173 22079 22079 4629 4629

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