albums_artists

4 rows where artist_id = 2545

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
3185 3185 3006 3006 2545 2545
5664 5664 5400 5400 2545 2545
5953 5953 5685 5685 2545 2545
11407 11407 11068 11068 2545 2545

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