albums_artists

10 rows where artist_id = 3720

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5383 5383 5131 5131 3720 3720
8278 8278 7959 7959 3720 3720
8423 8423 8097 8097 3720 3720
9717 9717 9371 9371 3720 3720
9999 9999 9655 9655 3720 3720
10630 10630 10296 10296 3720 3720
11317 11317 10980 10980 3720 3720
12725 12725 12386 12386 3720 3720
13316 13316 12969 12969 3720 3720
14293 14293 13935 13935 3720 3720

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