albums_artists

7 rows where artist_id = 4402

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id artist_id
6878 6878 6579 6579 4402 4402
7204 7204 6906 6906 4402 4402
9810 9810 9464 9464 4402 4402
10383 10383 10042 10042 4402 4402
12732 12732 12393 12393 4402 4402
14643 14643 14288 14288 4402 4402
15792 15792 15453 15453 4402 4402

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