albums_artists

5 rows where artist_id = 1617

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1823 1823 1722 1722 1617 1617
10531 10531 10193 10193 1617 1617
16581 16581 16271 16271 1617 1617
21234 21234 21109 21109 1617 1617
22586 22586 22492 22492 1617 1617

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