albums_artists

5 rows where artist_id = 199

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
204 204 197 197 199 199
1630 1630 1539 1539 199 199
4008 4008 3805 3805 199 199
6219 6219 5939 5939 199 199
8772 8772 8440 8440 199 199

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