albums_artists

5 rows where artist_id = 4801

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7801 7801 7489 7489 4801 4801
22511 22511 22416 22416 4801 4801
23003 23003 22908 22908 4801 4801
25743 25743 25643 25643 4801 4801
26326 26326 26221 26221 4801 4801

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