albums_artists

5 rows where artist_id = 4230

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6533 6533 6244 6244 4230 4230
9242 9242 8897 8897 4230 4230
11787 11787 11446 11446 4230 4230
13610 13610 13259 13259 4230 4230
15482 15482 15140 15140 4230 4230

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