albums_artists

3 rows where artist_id = 3166

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4287 4287 4082 4082 3166 3166
5218 5218 4973 4973 3166 3166
5957 5957 5689 5689 3166 3166

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