albums_artists

10 rows where artist_id = 250

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
256 256 245 245 250 250
12095 12095 11754 11754 250 250
16238 16238 15917 15917 250 250
17055 17055 16752 16752 250 250
19051 19051 18823 18823 250 250
20642 20642 20479 20479 250 250
23828 23828 23718 23718 250 250
24076 24076 23966 23966 250 250
24428 24428 24317 24317 250 250
24869 24869 24756 24756 250 250

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