albums_artists

8 rows where artist_id = 7917

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15742 15742 15405 15405 7917 7917
16515 16515 16201 16201 7917 7917
18236 18236 17958 17958 7917 7917
19610 19610 19403 19403 7917 7917
24640 24640 24517 24517 7917 7917
25646 25646 25548 25548 7917 7917
25792 25792 25693 25693 7917 7917
26031 26031 25932 25932 7917 7917

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