albums_artists

5 rows where artist_id = 4146

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6300 6300 6014 6014 4146 4146
6301 6301 6015 6015 4146 4146
6302 6302 6016 6016 4146 4146
6303 6303 6017 6017 4146 4146
19611 19611 19404 19404 4146 4146

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