albums_artists

8 rows where artist_id = 4232

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6536 6536 6247 6247 4232 4232
11347 11347 11011 11011 4232 4232
12798 12798 12456 12456 4232 4232
16830 16830 16521 16521 4232 4232
18691 18691 18444 18444 4232 4232
20093 20093 19912 19912 4232 4232
21069 21069 20931 20931 4232 4232
22044 22044 21945 21945 4232 4232

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