albums_artists

5 rows where artist_id = 5605

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9711 9711 9364 9364 5605 5605
12239 12239 11903 11903 5605 5605
15156 15156 14810 14810 5605 5605
17527 17527 17232 17232 5605 5605
19816 19816 19621 19621 5605 5605

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