albums_artists

12 rows where artist_id = 2755

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3548 3548 3351 3351 2755 2755
8702 8702 8370 8370 2755 2755
10097 10097 9752 9752 2755 2755
11302 11302 10964 10964 2755 2755
13538 13538 13187 13187 2755 2755
14522 14522 14166 14166 2755 2755
15994 15994 15656 15656 2755 2755
18134 18134 17850 17850 2755 2755
22188 22188 22094 22094 2755 2755
22796 22796 22706 22706 2755 2755
23853 23853 23741 23741 2755 2755
25715 25715 25615 25615 2755 2755

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