albums_artists

7 rows where artist_id = 2965

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3928 3928 3726 3726 2965 2965
7527 7527 7222 7222 2965 2965
15832 15832 15489 15489 2965 2965
20370 20370 20202 20202 2965 2965
24327 24327 24215 24215 2965 2965
25540 25540 25441 25441 2965 2965
26503 26503 26393 26393 2965 2965

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