albums_artists

6 rows where artist_id = 5810

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10174 10174 9834 9834 5810 5810
13613 13613 13263 13263 5810 5810
16419 16419 16105 16105 5810 5810
17688 17688 17393 17393 5810 5810
19398 19398 19182 19182 5810 5810
19781 19781 19586 19586 5810 5810

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