albums_artists

10 rows where artist_id = 3716

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5376 5376 5124 5124 3716 3716
6949 6949 6651 6651 3716 3716
13789 13789 13433 13433 3716 3716
14926 14926 14580 14580 3716 3716
15911 15911 15570 15570 3716 3716
18644 18644 18395 18395 3716 3716
21680 21680 21569 21569 3716 3716
24356 24356 24242 24242 3716 3716
25699 25699 25599 25599 3716 3716
26544 26544 26432 26432 3716 3716

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