albums_artists

5 rows where artist_id = 4347

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6777 6777 6482 6482 4347 4347
12525 12525 12186 12186 4347 4347
14959 14959 14609 14609 4347 4347
14960 14960 14610 14610 4347 4347
17752 17752 17458 17458 4347 4347

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