albums_artists

7 rows where artist_id = 455

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
466 466 446 446 455 455
15507 15507 15165 15165 455 455
18979 18979 18746 18746 455 455
19998 19998 19813 19813 455 455
22520 22520 22425 22425 455 455
23857 23857 23745 23745 455 455
25013 25013 24905 24905 455 455

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