albums_artists

9 rows where artist_id = 1413

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1554 1554 1465 1465 1413 1413
9867 9867 9521 9521 1413 1413
14486 14486 14130 14130 1413 1413
16487 16487 16173 16173 1413 1413
17641 17641 17346 17346 1413 1413
17940 17940 17648 17648 1413 1413
22039 22039 21939 21939 1413 1413
24571 24571 24451 24451 1413 1413
25925 25925 25827 25827 1413 1413

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