albums_artists

4 rows where artist_id = 4042

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6040 6040 5766 5766 4042 4042
8027 8027 7715 7715 4042 4042
19255 19255 19036 19036 4042 4042
19256 19256 19037 19037 4042 4042

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