albums_artists

7 rows where artist_id = 899

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
939 939 888 888 899 899
3824 3824 3623 3623 899 899
5475 5475 5219 5219 899 899
7708 7708 7402 7402 899 899
9466 9466 9119 9119 899 899
10422 10422 10080 10080 899 899
11925 11925 11582 11582 899 899

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