albums_artists

5 rows where artist_id = 3257

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4437 4437 4223 4223 3257 3257
6628 6628 6338 6338 3257 3257
15126 15126 14781 14781 3257 3257
19346 19346 19129 19129 3257 3257
26564 26564 26452 26452 3257 3257

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