albums_artists

5 rows where artist_id = 3753

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5462 5462 5205 5205 3753 3753
10376 10376 10035 10035 3753 3753
14080 14080 13725 13725 3753 3753
16636 16636 16325 16325 3753 3753
21300 21300 21176 21176 3753 3753

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