albums_artists

14 rows where artist_id = 905

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
946 946 894 894 905 905
2961 2961 2790 2790 905 905
4349 4349 4142 4142 905 905
4538 4538 4322 4322 905 905
5752 5752 5487 5487 905 905
10044 10044 9700 9700 905 905
11448 11448 11111 11111 905 905
13114 13114 12776 12776 905 905
17239 17239 16936 16936 905 905
17830 17830 17539 17539 905 905
21027 21027 20885 20885 905 905
21547 21547 21428 21428 905 905
22246 22246 22156 22156 905 905
22519 22519 22424 22424 905 905

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