albums_artists

10 rows where artist_id = 1051

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1111 1111 1049 1049 1051 1051
4345 4345 4140 4140 1051 1051
4585 4585 4369 4369 1051 1051
6685 6685 6394 6394 1051 1051
15708 15708 15371 15371 1051 1051
18874 18874 18631 18631 1051 1051
21207 21207 21081 21081 1051 1051
23084 23084 22984 22984 1051 1051
23185 23185 23084 23084 1051 1051
24364 24364 24250 24250 1051 1051

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