albums_artists

7 rows where artist_id = 5890

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10406 10406 10065 10065 5890 5890
16066 16066 15738 15738 5890 5890
16365 16365 16051 16051 5890 5890
20097 20097 19917 19917 5890 5890
21898 21898 21794 21794 5890 5890
23502 23502 23396 23396 5890 5890
25615 25615 25517 25517 5890 5890

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