albums_artists

5 rows where artist_id = 7902

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
15696 15696 15359 15359 7902 7902
17181 17181 16877 16877 7902 7902
17928 17928 17636 17636 7902 7902
18473 18473 18205 18205 7902 7902
20537 20537 20375 20375 7902 7902

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