albums_artists

7 rows where artist_id = 1138

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1238 1238 1165 1165 1138 1138
6249 6249 5964 5964 1138 1138
12700 12700 12361 12361 1138 1138
16291 16291 15975 15975 1138 1138
19761 19761 19565 19565 1138 1138
21959 21959 21859 21859 1138 1138
24871 24871 24758 24758 1138 1138

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