albums_artists

10 rows where artist_id = 6051

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10726 10726 10392 10392 6051 6051
15746 15746 15409 15409 6051 6051
16068 16068 15741 15741 6051 6051
19547 19547 19334 19334 6051 6051
23134 23134 23033 23033 6051 6051
24618 24618 24496 24496 6051 6051
25043 25043 24936 24936 6051 6051
25942 25942 25843 25843 6051 6051
26063 26063 25964 25964 6051 6051
26374 26374 26268 26268 6051 6051

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