albums_artists

7 rows where artist_id = 4539

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7183 7183 6884 6884 4539 4539
8513 8513 8181 8181 4539 4539
8514 8514 8182 8182 4539 4539
14580 14580 14226 14226 4539 4539
16460 16460 16147 16147 4539 4539
16461 16461 16148 16148 4539 4539
27249 27249 27086 27086 4539 4539

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