albums_artists

4 rows where artist_id = 3545

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5015 5015 4776 4776 3545 3545
6006 6006 5735 5735 3545 3545
6996 6996 6696 6696 3545 3545
26541 26541 26430 26430 3545 3545

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