albums_artists

8 rows where artist_id = 244

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
250 250 239 239 244 244
2997 2997 2825 2825 244 244
7159 7159 6859 6859 244 244
13489 13489 13137 13137 244 244
16053 16053 15723 15723 244 244
18524 18524 18262 18262 244 244
26258 26258 26156 26156 244 244
26263 26263 26161 26161 244 244

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