albums_artists

5 rows where artist_id = 2070

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2446 2446 2295 2295 2070 2070
6214 6214 5934 5934 2070 2070
7202 7202 6904 6904 2070 2070
10333 10333 9990 9990 2070 2070
27230 27230 27069 27069 2070 2070

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