albums_artists

11 rows where artist_id = 3449

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4783 4783 4566 4566 3449 3449
11970 11970 11627 11627 3449 3449
14950 14950 14600 14600 3449 3449
18641 18641 18391 18391 3449 3449
20607 20607 20443 20443 3449 3449
21932 21932 21831 21831 3449 3449
23196 23196 23093 23093 3449 3449
23259 23259 23157 23157 3449 3449
25781 25781 25682 25682 3449 3449
26799 26799 26664 26664 3449 3449
27334 27334 27166 27166 3449 3449

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