albums_artists

6 rows where artist_id = 7936

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15804 15804 15462 15462 7936 7936
20303 20303 20132 20132 7936 7936
22423 22423 22328 22328 7936 7936
25867 25867 25769 25769 7936 7936
26040 26040 25941 25941 7936 7936
26120 26120 26017 26017 7936 7936

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