albums_artists

4 rows where artist_id = 1248

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
1356 1356 1277 1277 1248 1248
6865 6865 6566 6566 1248 1248
8560 8560 8227 8227 1248 1248
21358 21358 21235 21235 1248 1248

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