albums_artists

17 rows where artist_id = 72

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
77 77 75 75 72 72
1122 1122 1059 1059 72 72
1561 1561 1472 1472 72 72
2651 2651 2492 2492 72 72
4013 4013 3810 3810 72 72
5411 5411 5159 5159 72 72
12386 12386 12050 12050 72 72
13010 13010 12668 12668 72 72
15638 15638 15299 15299 72 72
17875 17875 17582 17582 72 72
18669 18669 18421 18421 72 72
19752 19752 19556 19556 72 72
22210 22210 22118 22118 72 72
24419 24419 24307 24307 72 72
24627 24627 24505 24505 72 72
26470 26470 26360 26360 72 72
27005 27005 26856 26856 72 72

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