albums_artists

5 rows where artist_id = 4031

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6015 6015 5744 5744 4031 4031
7463 7463 7159 7159 4031 4031
7573 7573 7268 7268 4031 4031
7575 7575 7269 7269 4031 4031
8101 8101 7784 7784 4031 4031

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