albums_artists

7 rows where artist_id = 2292

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
2786 2786 2621 2621 2292 2292
5429 5429 5175 5175 2292 2292
6378 6378 6089 6089 2292 2292
9028 9028 8688 8688 2292 2292
10893 10893 10552 10552 2292 2292
11866 11866 11524 11524 2292 2292
26865 26865 26724 26724 2292 2292

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