albums_artists

16 rows where artist_id = 3154

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4259 4259 4056 4056 3154 3154
5047 5047 4808 4808 3154 3154
8425 8425 8099 8099 3154 3154
8890 8890 8556 8556 3154 3154
11440 11440 11101 11101 3154 3154
12521 12521 12182 12182 3154 3154
13969 13969 13613 13613 3154 3154
14778 14778 14423 14423 3154 3154
17160 17160 16858 16858 3154 3154
19590 19590 19379 19379 3154 3154
19958 19958 19770 19770 3154 3154
22403 22403 22309 22309 3154 3154
24102 24102 23992 23992 3154 3154
24639 24639 24516 24516 3154 3154
25011 25011 24903 24903 3154 3154
26694 26694 26567 26567 3154 3154

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