albums_artists

6 rows where artist_id = 4063

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6087 6087 5811 5811 4063 4063
9367 9367 9019 9019 4063 4063
13769 13769 13414 13414 4063 4063
14288 14288 13931 13931 4063 4063
17408 17408 17114 17114 4063 4063
26428 26428 26320 26320 4063 4063

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