albums_artists

6 rows where artist_id = 4672

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7490 7490 7185 7185 4672 4672
8241 8241 7921 7921 4672 4672
11264 11264 10928 10928 4672 4672
14569 14569 14215 14215 4672 4672
19584 19584 19372 19372 4672 4672
24010 24010 23899 23899 4672 4672

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