albums_artists

6 rows where artist_id = 2835

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3697 3697 3498 3498 2835 2835
5349 5349 5099 5099 2835 2835
6083 6083 5807 5807 2835 2835
7570 7570 7265 7265 2835 2835
12346 12346 12010 12010 2835 2835
19134 19134 18910 18910 2835 2835

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