albums_artists

5 rows where artist_id = 918

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
960 960 905 905 918 918
2188 2188 2053 2053 918 918
6350 6350 6060 6060 918 918
9589 9589 9243 9243 918 918
10205 10205 9866 9866 918 918

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