albums_artists

5 rows where artist_id = 4010

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5975 5975 5704 5704 4010 4010
7136 7136 6837 6837 4010 4010
7740 7740 7433 7433 4010 4010
8020 8020 7707 7707 4010 4010
12327 12327 11990 11990 4010 4010

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