albums_artists

4 rows where artist_id = 1395

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1529 1529 1443 1443 1395 1395
13146 13146 12807 12807 1395 1395
14443 14443 14087 14087 1395 1395
14956 14956 14606 14606 1395 1395

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