albums_artists

6 rows where artist_id = 3077

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4118 4118 3918 3918 3077 3077
9831 9831 9484 9484 3077 3077
11423 11423 11084 11084 3077 3077
16190 16190 15868 15868 3077 3077
19175 19175 18953 18953 3077 3077
21452 21452 21332 21332 3077 3077

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