albums_artists

11 rows where artist_id = 5384

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9234 9234 8889 8889 5384 5384
11185 11185 10847 10847 5384 5384
11526 11526 11189 11189 5384 5384
11973 11973 11631 11631 5384 5384
15336 15336 14994 14994 5384 5384
18104 18104 17818 17818 5384 5384
20686 20686 20524 20524 5384 5384
22555 22555 22461 22461 5384 5384
23334 23334 23230 23230 5384 5384
25725 25725 25625 25625 5384 5384
26245 26245 26142 26142 5384 5384

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