albums_artists

5 rows where artist_id = 4255

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6577 6577 6289 6289 4255 4255
10911 10911 10570 10570 4255 4255
14410 14410 14052 14052 4255 4255
16944 16944 16636 16636 4255 4255
18489 18489 18222 18222 4255 4255

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