albums_artists

11 rows where artist_id = 1063

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1127 1127 1064 1064 1063 1063
3200 3200 3019 3019 1063 1063
5720 5720 5458 5458 1063 1063
7472 7472 7168 7168 1063 1063
9189 9189 8846 8846 1063 1063
11569 11569 11231 11231 1063 1063
12579 12579 12239 12239 1063 1063
13733 13733 13378 13378 1063 1063
14126 14126 13771 13771 1063 1063
14636 14636 14281 14281 1063 1063
26944 26944 26799 26799 1063 1063

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