albums_artists

6 rows where artist_id = 3106

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4176 4176 3974 3974 3106 3106
10785 10785 10448 10448 3106 3106
19710 19710 19513 19513 3106 3106
22448 22448 22352 22352 3106 3106
23803 23803 23693 23693 3106 3106
24915 24915 24806 24806 3106 3106

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