albums_artists

9 rows where artist_id = 1683

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1906 1906 1798 1798 1683 1683
3439 3439 3246 3246 1683 1683
5951 5951 5683 5683 1683 1683
8671 8671 8337 8337 1683 1683
12738 12738 12399 12399 1683 1683
13577 13577 13226 13226 1683 1683
15985 15985 15646 15646 1683 1683
19676 19676 19477 19477 1683 1683
21381 21381 21259 21259 1683 1683

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