albums_artists

7 rows where artist_id = 992

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1047 1047 990 990 992 992
3641 3641 3446 3446 992 992
4199 4199 3997 3997 992 992
8387 8387 8062 8062 992 992
11326 11326 10988 10988 992 992
13672 13672 13321 13321 992 992
15603 15603 15265 15265 992 992

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