albums_artists

6 rows where artist_id = 3563

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5066 5066 4825 4825 3563 3563
11374 11374 11035 11035 3563 3563
21208 21208 21082 21082 3563 3563
22932 22932 22835 22835 3563 3563
25665 25665 25566 25566 3563 3563
26166 26166 26064 26064 3563 3563

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