albums_artists

6 rows where artist_id = 9894

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
21260 21260 21136 21136 9894 9894
23856 23856 23744 23744 9894 9894
24700 24700 24578 24578 9894 9894
25628 25628 25530 25530 9894 9894
25642 25642 25544 25544 9894 9894
27292 27292 27125 27125 9894 9894

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