albums_artists

8 rows where artist_id = 2304

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2801 2801 2636 2636 2304 2304
8288 8288 7969 7969 2304 2304
10629 10629 10295 10295 2304 2304
11620 11620 11283 11283 2304 2304
13954 13954 13597 13597 2304 2304
14347 14347 13988 13988 2304 2304
14761 14761 14407 14407 2304 2304
16175 16175 15853 15853 2304 2304

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