albums_artists

6 rows where artist_id = 4175

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6408 6408 6116 6116 4175 4175
16280 16280 15964 15964 4175 4175
16706 16706 16396 16396 4175 4175
17128 17128 16831 16831 4175 4175
17129 17129 16832 16832 4175 4175
21026 21026 20884 20884 4175 4175

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