albums_artists

7 rows where artist_id = 1010

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1068 1068 1012 1012 1010 1010
3715 3715 3516 3516 1010 1010
4804 4804 4586 4586 1010 1010
5582 5582 5323 5323 1010 1010
7075 7075 6777 6777 1010 1010
10803 10803 10466 10466 1010 1010
13647 13647 13296 13296 1010 1010

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