albums_artists

5 rows where artist_id = 5848

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10282 10282 9941 9941 5848 5848
10283 10283 9942 9942 5848 5848
10284 10284 9943 9943 5848 5848
24291 24291 24181 24181 5848 5848
26020 26020 25921 25921 5848 5848

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