albums_artists

7 rows where artist_id = 3189

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4324 4324 4120 4120 3189 3189
9566 9566 9220 9220 3189 3189
13129 13129 12790 12790 3189 3189
15261 15261 14916 14916 3189 3189
15774 15774 15436 15436 3189 3189
18118 18118 17833 17833 3189 3189
26720 26720 26591 26591 3189 3189

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