albums_artists

6 rows where artist_id = 8454

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
17165 17165 16862 16862 8454 8454
18877 18877 18633 18633 8454 8454
20980 20980 20834 20834 8454 8454
23800 23800 23690 23690 8454 8454
24438 24438 24327 24327 8454 8454
26446 26446 26338 26338 8454 8454

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