albums_artists

5 rows where artist_id = 2838

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3701 3701 3501 3501 2838 2838
7029 7029 6730 6730 2838 2838
9325 9325 8978 8978 2838 2838
10584 10584 10246 10246 2838 2838
26469 26469 26359 26359 2838 2838

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