albums_artists

8 rows where artist_id = 3551

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5038 5038 4799 4799 3551 3551
5991 5991 5720 5720 3551 3551
12133 12133 11794 11794 3551 3551
18071 18071 17783 17783 3551 3551
18072 18072 17784 17784 3551 3551
20719 20719 20559 20559 3551 3551
24749 24749 24629 24629 3551 3551
26175 26175 26073 26073 3551 3551

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