albums_artists

5 rows where artist_id = 7315

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
13985 13985 13630 13630 7315 7315
17475 17475 17181 17181 7315 7315
19889 19889 19700 19700 7315 7315
21294 21294 21170 21170 7315 7315
23871 23871 23759 23759 7315 7315

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