albums_artists

6 rows where artist_id = 4417

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6913 6913 6614 6614 4417 4417
21022 21022 20880 20880 4417 4417
21023 21023 20881 20881 4417 4417
21024 21024 20882 20882 4417 4417
22218 22218 22127 22127 4417 4417
27113 27113 26955 26955 4417 4417

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