albums_artists

11 rows where artist_id = 3406

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
4698 4698 4481 4481 3406 3406
5814 5814 5547 5547 3406 3406
12818 12818 12476 12476 3406 3406
15803 15803 15462 15462 3406 3406
17711 17711 17416 17416 3406 3406
18590 18590 18338 18338 3406 3406
18765 18765 18523 18523 3406 3406
20647 20647 20484 20484 3406 3406
23038 23038 22942 22942 3406 3406
23537 23537 23433 23433 3406 3406
25727 25727 25627 25627 3406 3406

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