albums_artists

6 rows where artist_id = 1610

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1814 1814 1713 1713 1610 1610
5398 5398 5146 5146 1610 1610
10747 10747 10413 10413 1610 1610
14772 14772 14417 14417 1610 1610
19742 19742 19546 19546 1610 1610
22059 22059 21961 21961 1610 1610

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