albums_artists

10 rows where artist_id = 3399

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4687 4687 4471 4471 3399 3399
5515 5515 5259 5259 3399 3399
9014 9014 8674 8674 3399 3399
12023 12023 11682 11682 3399 3399
14725 14725 14371 14371 3399 3399
15227 15227 14882 14882 3399 3399
16841 16841 16532 16532 3399 3399
17509 17509 17214 17214 3399 3399
19385 19385 19170 19170 3399 3399
19649 19649 19447 19447 3399 3399

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