albums_artists

6 rows where artist_id = 680

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
704 704 672 672 680 680
6990 6990 6691 6691 680 680
8546 8546 8213 8213 680 680
9757 9757 9411 9411 680 680
12666 12666 12326 12326 680 680
14230 14230 13870 13870 680 680

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