albums_artists

6 rows where artist_id = 2075

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2453 2453 2302 2302 2075 2075
2794 2794 2629 2629 2075 2075
11320 11320 10983 10983 2075 2075
16892 16892 16582 16582 2075 2075
18806 18806 18563 18563 2075 2075
20708 20708 20548 20548 2075 2075

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