albums_artists

6 rows where artist_id = 7079

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13279 13279 12934 12934 7079 7079
15891 15891 15548 15548 7079 7079
18109 18109 17823 17823 7079 7079
22196 22196 22103 22103 7079 7079
22702 22702 22610 22610 7079 7079
25173 25173 25067 25067 7079 7079

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