albums_artists

7 rows where artist_id = 2848

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3717 3717 3518 3518 2848 2848
5875 5875 5608 5608 2848 2848
9850 9850 9502 9502 2848 2848
12301 12301 11963 11963 2848 2848
13310 13310 12963 12963 2848 2848
15065 15065 14720 14720 2848 2848
26538 26538 26427 26427 2848 2848

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