albums_artists

11 rows where artist_id = 686

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
711 711 678 678 686 686
1847 1847 1745 1745 686 686
4076 4076 3876 3876 686 686
10749 10749 10415 10415 686 686
13772 13772 13416 13416 686 686
15647 15647 15309 15309 686 686
18246 18246 17968 17968 686 686
20077 20077 19896 19896 686 686
20332 20332 20162 20162 686 686
22517 22517 22422 22422 686 686
24097 24097 23987 23987 686 686

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