albums_artists

9 rows where artist_id = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
53 53 51 51 48 48
534 534 512 512 48 48
1148 1148 1080 1080 48 48
2078 2078 1952 1952 48 48
3671 3671 3473 3473 48 48
7793 7793 7481 7481 48 48
12640 12640 12301 12301 48 48
13166 13166 12826 12826 48 48
19789 19789 19593 19593 48 48

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