albums_artists

8 rows where artist_id = 824

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
859 859 813 813 824 824
860 860 814 814 824 824
861 861 815 815 824 824
12459 12459 12121 12121 824 824
20119 20119 19942 19942 824 824
21263 21263 21139 21139 824 824
23694 23694 23588 23588 824 824
26113 26113 26009 26009 824 824

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