albums_artists

6 rows where artist_id = 4846

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
7926 7926 7613 7613 4846 4846
8592 8592 8259 8259 4846 4846
10739 10739 10405 10405 4846 4846
18402 18402 18131 18131 4846 4846
21411 21411 21289 21289 4846 4846
22275 22275 22184 22184 4846 4846

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