albums_artists

7 rows where artist_id = 1861

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2153 2153 2020 2020 1861 1861
4906 4906 4678 4678 1861 1861
6290 6290 6004 6004 1861 1861
7141 7141 6842 6842 1861 1861
8361 8361 8037 8037 1861 1861
8980 8980 8640 8640 1861 1861
9912 9912 9566 9566 1861 1861

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