albums_artists

8 rows where artist_id = 1815

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2084 2084 1957 1957 1815 1815
7639 7639 7333 7333 1815 1815
15071 15071 14726 14726 1815 1815
17660 17660 17365 17365 1815 1815
19422 19422 19206 19206 1815 1815
22219 22219 22128 22128 1815 1815
23719 23719 23610 23610 1815 1815
23868 23868 23756 23756 1815 1815

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