albums_artists

12 rows where artist_id = 1896

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2199 2199 2063 2063 1896 1896
3425 3425 3233 3233 1896 1896
4082 4082 3882 3882 1896 1896
8957 8957 8619 8619 1896 1896
10982 10982 10640 10640 1896 1896
13478 13478 13126 13126 1896 1896
17121 17121 16823 16823 1896 1896
17605 17605 17310 17310 1896 1896
19275 19275 19056 19056 1896 1896
20536 20536 20374 20374 1896 1896
21955 21955 21855 21855 1896 1896
23746 23746 23636 23636 1896 1896

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