albums_artists

5 rows where artist_id = 3998

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5948 5948 5680 5680 3998 3998
11488 11488 11151 11151 3998 3998
12187 12187 11850 11850 3998 3998
20069 20069 19887 19887 3998 3998
27604 27604 27413 27413 3998 3998

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