albums_artists

5 rows where artist_id = 2006

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2355 2355 2209 2209 2006 2006
4966 4966 4732 4732 2006 2006
7761 7761 7453 7453 2006 2006
13099 13099 12761 12761 2006 2006
27524 27524 27339 27339 2006 2006

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