albums_artists

11 rows where artist_id = 5778

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10078 10078 9734 9734 5778 5778
14991 14991 14643 14643 5778 5778
14992 14992 14644 14644 5778 5778
14993 14993 14645 14645 5778 5778
14994 14994 14646 14646 5778 5778
15076 15076 14731 14731 5778 5778
15077 15077 14732 14732 5778 5778
15078 15078 14733 14733 5778 5778
15079 15079 14734 14734 5778 5778
15080 15080 14735 14735 5778 5778
18791 18791 18548 18548 5778 5778

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