albums_artists

7 rows where artist_id = 3987

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5929 5929 5661 5661 3987 3987
11615 11615 11278 11278 3987 3987
16794 16794 16486 16486 3987 3987
17272 17272 16969 16969 3987 3987
21211 21211 21085 21085 3987 3987
23119 23119 23018 23018 3987 3987
23367 23367 23264 23264 3987 3987

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