albums_artists

13 rows where artist_id = 3083

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4127 4127 3927 3927 3083 3083
5979 5979 5708 5708 3083 3083
9636 9636 9288 9288 3083 3083
11779 11779 11439 11439 3083 3083
12794 12794 12452 12452 3083 3083
13800 13800 13445 13445 3083 3083
17675 17675 17380 17380 3083 3083
20569 20569 20408 20408 3083 3083
21280 21280 21156 21156 3083 3083
23058 23058 22959 22959 3083 3083
24283 24283 24175 24175 3083 3083
25707 25707 25607 25607 3083 3083
26051 26051 25952 25952 3083 3083

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