albums_artists

6 rows where artist_id = 3088

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4139 4139 3938 3938 3088 3088
8433 8433 8106 8106 3088 3088
12890 12890 12547 12547 3088 3088
14916 14916 14570 14570 3088 3088
16003 16003 15667 15667 3088 3088
18731 18731 18487 18487 3088 3088

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