albums_artists

5 rows where artist_id = 2722

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3487 3487 3291 3291 2722 2722
13747 13747 13393 13393 2722 2722
15896 15896 15554 15554 2722 2722
16094 16094 15766 15766 2722 2722
16095 16095 15767 15767 2722 2722

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