albums_artists

13 rows where artist_id = 3138

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4239 4239 4038 4038 3138 3138
5652 5652 5389 5389 3138 3138
6468 6468 6176 6176 3138 3138
9414 9414 9066 9066 3138 3138
11964 11964 11621 11621 3138 3138
15683 15683 15345 15345 3138 3138
18066 18066 17778 17778 3138 3138
19261 19261 19042 19042 3138 3138
21849 21849 21745 21745 3138 3138
23528 23528 23424 23424 3138 3138
25544 25544 25445 25445 3138 3138
26745 26745 26614 26614 3138 3138
27144 27144 26985 26985 3138 3138

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