albums_artists

6 rows where artist_id = 8565

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
17454 17454 17160 17160 8565 8565
19832 19832 19638 19638 8565 8565
19845 19845 19651 19651 8565 8565
23166 23166 23065 23065 8565 8565
23854 23854 23742 23742 8565 8565
24996 24996 24888 24888 8565 8565

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