albums_artists

4 rows where artist_id = 6628

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
12061 12061 11720 11720 6628 6628
13844 13844 13486 13486 6628 6628
17260 17260 16957 16957 6628 6628
22718 22718 22626 22626 6628 6628

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