albums_artists

7 rows where artist_id = 4945

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
8169 8169 7851 7851 4945 4945
8170 8170 7852 7852 4945 4945
8171 8171 7853 7853 4945 4945
8172 8172 7854 7854 4945 4945
8173 8173 7855 7855 4945 4945
8174 8174 7856 7856 4945 4945
8175 8175 7857 7857 4945 4945

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