albums_artists

5 rows where artist_id = 8090

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
16178 16178 15856 15856 8090 8090
19631 19631 19426 19426 8090 8090
22112 22112 22015 22015 8090 8090
23980 23980 23867 23867 8090 8090
25155 25155 25050 25050 8090 8090

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