albums_artists

16 rows where artist_id = 676

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
700 700 668 668 676 676
1948 1948 1834 1834 676 676
1976 1976 1860 1860 676 676
2094 2094 1965 1965 676 676
2233 2233 2094 2094 676 676
2284 2284 2141 2141 676 676
2571 2571 2419 2419 676 676
2584 2584 2432 2432 676 676
2713 2713 2551 2551 676 676
2770 2770 2605 2605 676 676
2863 2863 2696 2696 676 676
2953 2953 2782 2782 676 676
3250 3250 3067 3067 676 676
3296 3296 3113 3113 676 676
26568 26568 26456 26456 676 676
26602 26602 26487 26487 676 676

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