albums_artists

6 rows where artist_id = 4327

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6735 6735 6442 6442 4327 4327
8438 8438 8111 8111 4327 4327
11023 11023 10682 10682 4327 4327
12997 12997 12654 12654 4327 4327
14281 14281 13925 13925 4327 4327
14809 14809 14456 14456 4327 4327

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