albums_artists

5 rows where artist_id = 3428

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4737 4737 4521 4521 3428 3428
10342 10342 10000 10000 3428 3428
13935 13935 13577 13577 3428 3428
17958 17958 17666 17666 3428 3428
20142 20142 19965 19965 3428 3428

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