albums_artists

7 rows where artist_id = 576

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
595 595 571 571 576 576
2068 2068 1945 1945 576 576
3003 3003 2830 2830 576 576
6926 6926 6627 6627 576 576
10315 10315 9971 9971 576 576
13528 13528 13177 13177 576 576
15445 15445 15103 15103 576 576

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