albums_artists

10 rows where artist_id = 690

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
716 716 683 683 690 690
3861 3861 3657 3657 690 690
6854 6854 6555 6555 690 690
8978 8978 8638 8638 690 690
12038 12038 11697 11697 690 690
15097 15097 14752 14752 690 690
15324 15324 14983 14983 690 690
19540 19540 19327 19327 690 690
22831 22831 22740 22740 690 690
23203 23203 23099 23099 690 690

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