albums_artists

8 rows where artist_id = 3723

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5393 5393 5141 5141 3723 3723
14492 14492 14136 14136 3723 3723
17533 17533 17239 17239 3723 3723
18837 18837 18593 18593 3723 3723
19253 19253 19034 19034 3723 3723
21377 21377 21254 21254 3723 3723
21811 21811 21706 21706 3723 3723
22616 22616 22523 22523 3723 3723

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