albums_artists

8 rows where artist_id = 5917

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10457 10457 10115 10115 5917 5917
12493 12493 12155 12155 5917 5917
14372 14372 14013 14013 5917 5917
17575 17575 17279 17279 5917 5917
19417 19417 19201 19201 5917 5917
21221 21221 21096 21096 5917 5917
21837 21837 21733 21733 5917 5917
23595 23595 23492 23492 5917 5917

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