albums_artists

5 rows where artist_id = 1050

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1110 1110 1048 1048 1050 1050
4545 4545 4329 4329 1050 1050
7342 7342 7045 7045 1050 1050
12096 12096 11755 11755 1050 1050
24974 24974 24866 24866 1050 1050

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