albums_artists

8 rows where artist_id = 3000

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3984 3984 3780 3780 3000 3000
7105 7105 6806 6806 3000 3000
7436 7436 7137 7137 3000 3000
10673 10673 10338 10338 3000 3000
11312 11312 10975 10975 3000 3000
12564 12564 12224 12224 3000 3000
14623 14623 14268 14268 3000 3000
15202 15202 14856 14856 3000 3000

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