albums_artists

6 rows where artist_id = 4164

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6371 6371 6082 6082 4164 4164
9259 9259 8913 8913 4164 4164
11573 11573 11235 11235 4164 4164
12683 12683 12343 12343 4164 4164
13976 13976 13621 13621 4164 4164
27512 27512 27330 27330 4164 4164

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