albums_artists

14 rows where artist_id = 5383

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
9231 9231 8886 8886 5383 5383
20548 20548 20386 20386 5383 5383
21096 21096 20963 20963 5383 5383
21150 21150 21022 21022 5383 5383
21151 21151 21023 21023 5383 5383
21152 21152 21024 21024 5383 5383
21408 21408 21286 21286 5383 5383
21409 21409 21287 21287 5383 5383
21410 21410 21288 21288 5383 5383
21874 21874 21770 21770 5383 5383
21875 21875 21771 21771 5383 5383
21876 21876 21772 21772 5383 5383
22094 22094 21997 21997 5383 5383
22095 22095 21998 21998 5383 5383

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