albums_artists

7 rows where artist_id = 516

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
529 529 508 508 516 516
1441 1441 1357 1357 516 516
2268 2268 2126 2126 516 516
2483 2483 2332 2332 516 516
3626 3626 3430 3430 516 516
7727 7727 7420 7420 516 516
27593 27593 27403 27403 516 516

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