albums_artists

11 rows where artist_id = 4755

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7699 7699 7393 7393 4755 4755
7700 7700 7394 7394 4755 4755
7701 7701 7395 7395 4755 4755
7702 7702 7396 7396 4755 4755
7703 7703 7397 7397 4755 4755
7704 7704 7398 7398 4755 4755
15472 15472 15133 15133 4755 4755
15959 15959 15620 15620 4755 4755
16932 16932 16624 16624 4755 4755
19920 19920 19732 19732 4755 4755
21100 21100 20967 20967 4755 4755

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