albums_artists

5 rows where artist_id = 1079

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1152 1152 1084 1084 1079 1079
2800 2800 2635 2635 1079 1079
4488 4488 4271 4271 1079 1079
4927 4927 4694 4694 1079 1079
5487 5487 5231 5231 1079 1079

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