albums_artists

10 rows where artist_id = 1937

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2246 2246 2107 2107 1937 1937
4708 4708 4491 4491 1937 1937
7126 7126 6827 6827 1937 1937
7127 7127 6828 6828 1937 1937
10079 10079 9735 9735 1937 1937
14367 14367 14008 14008 1937 1937
18483 18483 18215 18215 1937 1937
20680 20680 20518 20518 1937 1937
21801 21801 21695 21695 1937 1937
24099 24099 23989 23989 1937 1937

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