albums_artists

7 rows where artist_id = 5784

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
10103 10103 9760 9760 5784 5784
14583 14583 14229 14229 5784 5784
17640 17640 17345 17345 5784 5784
19408 19408 19192 19192 5784 5784
20287 20287 20114 20114 5784 5784
23123 23123 23022 23022 5784 5784
23793 23793 23683 23683 5784 5784

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