albums_artists

6 rows where artist_id = 3748

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
5454 5454 5197 5197 3748 3748
14866 14866 14518 14518 3748 3748
24926 24926 24817 24817 3748 3748
25117 25117 25013 25013 3748 3748
26246 26246 26143 26143 3748 3748
26286 26286 26183 26183 3748 3748

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