albums_artists

7 rows where artist_id = 10809

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
24018 24018 23907 23907 10809 10809
24294 24294 24184 24184 10809 10809
24733 24733 24614 24614 10809 10809
25026 25026 24919 24919 10809 10809
25367 25367 25270 25270 10809 10809
25776 25776 25677 25677 10809 10809
26319 26319 26214 26214 10809 10809

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