albums_artists

7 rows where artist_id = 2046

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2410 2410 2260 2260 2046 2046
6524 6524 6233 6233 2046 2046
7921 7921 7606 7606 2046 2046
10718 10718 10383 10383 2046 2046
15028 15028 14681 14681 2046 2046
15626 15626 15288 15288 2046 2046
17482 17482 17188 17188 2046 2046

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