albums_artists

9 rows where artist_id = 4628

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7365 7365 7066 7066 4628 4628
7554 7554 7249 7249 4628 4628
7892 7892 7575 7575 4628 4628
10836 10836 10499 10499 4628 4628
11195 11195 10857 10857 4628 4628
12307 12307 11969 11969 4628 4628
12308 12308 11970 11970 4628 4628
13299 13299 12953 12953 4628 4628
13644 13644 13292 13292 4628 4628

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