albums_artists

7 rows where artist_id = 3962

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5882 5882 5615 5615 3962 3962
6264 6264 5978 5978 3962 3962
7923 7923 7610 7610 3962 3962
11037 11037 10696 10696 3962 3962
14468 14468 14111 14111 3962 3962
16511 16511 16197 16197 3962 3962
17397 17397 17101 17101 3962 3962

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