albums_artists

8 rows where artist_id = 3513

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4931 4931 4698 4698 3513 3513
18421 18421 18151 18151 3513 3513
18423 18423 18152 18152 3513 3513
23146 23146 23045 23045 3513 3513
25933 25933 25834 25834 3513 3513
26136 26136 26033 26033 3513 3513
26137 26137 26034 26034 3513 3513
26169 26169 26067 26067 3513 3513

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