albums_artists

6 rows where artist_id = 4169

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6385 6385 6095 6095 4169 4169
13421 13421 13071 13071 4169 4169
14871 14871 14524 14524 4169 4169
16599 16599 16288 16288 4169 4169
17427 17427 17133 17133 4169 4169
21216 21216 21090 21090 4169 4169

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